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

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

Hello FK,
Many thanks for your help, I have just tried it out and it gave me the required result.
Best regards,
Hugh

You're welcome.
Good luck on future projects!