I am not understanding Reports at all!

[Manc]

Hi there

I've been looking at the Northwind 2007 demo and playing about with it and have printed of an invoice from it relating to ONE sales order.

When I go into my 'masterpiece', (I have designed a report/invoice), when i go to a specific record and view report, it shows every record, not just the one I am viewing, which is what I need it to do.

Please advise.

Thanks for your help.
Manc

 

[statsman]

How are you getting Access to supply the data for this report. Are you drawing it straight from the table or are you using a query?

If you are getting the data straight from the table, you will probably get all of the data in the table on your report. You should be using a query to restrict the data to only the record(s) you want.