Full Version: record suppression on report
UtterAccess Forums > MicrosoftŪ Access > Access Forms
hmiddity
Hello, I would like to print a report of a table of invoices. However I only want to print some of the records but I want to include the value of all records in the total.
So can anyone inform me of how I can select only certain records to print yet still include their value in the report total? There is a field in the table which I can use to identify the records to be printed.
Regards,
Hugh
freakazeud
Hi,
filter out the records to only include the ones you want to see on screen. You can do that with a query that you base your report on or a filter on the reports open event. Then use a Dsum function to calculate the total you want to display as well on the report.
HTH
Good luck
hmiddity
Hello FK,
Many thanks for your help, I have just tried it out and it gave me the required result.
Best regards,
Hugh
freakazeud
You're welcome.
Good luck on future projects!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.