Full Version: record suppression on report
UtterAccess Forums > MicrosoftŪ Access > Access Forms
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.
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.
Good luck
Hello FK,
Many thanks for your help, I have just tried it out and it gave me the required result.
Best regards,
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.