Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-12-2018, 03:21 PM   #16
unclefink
Newly Registered User
 
Join Date: May 2012
Location: Seattle, Washington
Posts: 180
Thanks: 36
Thanked 1 Time in 1 Post
unclefink is on a distinguished road
Re: Report resulting repetitive pages for every record.

Quote:
Originally Posted by pbaldy View Post
The field in red should be the one you want to sum up, not the one you're filtering on:

Dsum("casenumber","maindatatbl","casenumber like 'BP*'")
How should I put that in syntax if I want to count the number of records from that field while applying the filter.

unclefink is offline   Reply With Quote
Old 12-12-2018, 03:29 PM   #17
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,471
Thanks: 10
Thanked 3,948 Times in 3,888 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Report resulting repetitive pages for every record.

You can use DCount() instead of DSum() if you want a count.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Old 12-31-2018, 10:10 AM   #18
unclefink
Newly Registered User
 
Join Date: May 2012
Location: Seattle, Washington
Posts: 180
Thanks: 36
Thanked 1 Time in 1 Post
unclefink is on a distinguished road
Re: Report resulting repetitive pages for every record.

Thank you very much everyone, I have solved the issue based on your feedback. I appreciate your help

unclefink is offline   Reply With Quote
Old 12-31-2018, 10:12 AM   #19
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,471
Thanks: 10
Thanked 3,948 Times in 3,888 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Report resulting repetitive pages for every record.

Glad you got it sorted.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report creating extra pages based on number of sub report entries NLW-John Reports 5 11-01-2018 12:33 AM
Many images in report resulting in slowdown swift Reports 0 04-21-2007 09:58 AM
count resulting record from SQL expression? pungentSapling Modules & VBA 2 06-06-2003 05:09 AM
Getting a report to print a qty of pages when there is only one record shown!! Matt Brown Reports 2 11-21-2002 12:29 AM
Web pages from report pages Len Lee Reports 0 05-15-2002 06:42 AM




All times are GMT -8. The time now is 11:22 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World