hmiddity
Aug 5 2008, 08:42 AM
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
Aug 5 2008, 08:47 AM
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
Aug 5 2008, 09:06 AM
Hello FK,
Many thanks for your help, I have just tried it out and it gave me the required result.
Best regards,
Hugh
freakazeud
Aug 5 2008, 01:18 PM
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.