one record per report

[w9707384]

I have created a purchase order report using the wizard but everytime I preview all the purchase order records are shown, I have tried Force New Page, but this is not the solution. If anybody knows how to do it, let me know please.

 

[jon kemp]

Your problem is that a report will always want to list all the records from within the table / query.

To get around this create a parameter Query.

1. Make a new query with the relative fields however in the criteria of the purchase order field put this in = [enter purchase number]

2. If you then run the query you should be asked for the purchase number before you see the results.

3. Save this query and then base a report on it. As a result the report should ask you for a purchase number then display only that one record.

Good Luck.