Duplicate Reports

[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

 

[Duane Hookom]

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.