Duplicate Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report for a seating plan for a dinner. The report uses a DLookUp
function to get the name of each guest against a seat number I have allocated
to them and then puts the correct name agains the relevant seat number in the
report. There are 280 seats for this dinner and when I run the report I end
up getting 280 duplicate copies of the same seating plan. How do I get the
report to only show one copy or alternatively how can I automate a print
function to ensure that when the plan is printed only one page is printed.

Thanks
 
If you are using DLookup() to pull your data, you might not need any record
source for your report.

This sounds like a very slow running report.
 
Back
Top