Creating an Invoice

[jimd1768]

I am trying to generate an invoice for each customer order. I have created a query with all the information required. I am now trying to transfer that information into a report. The problem I have:

When I create the report, it shows all customer orders. I realise I have to modify the design.
I don't know how to show one customers order on the report.

Any help would be great.

Thank you

 

[jimd1768]

Thank you for the response.

This doesn't work on the report but does work on the query.
The report still gives me a list of that customers orders and not individual orders.

Example: Cust1 has 2 orders - Order1 & Order6

The report is showing both orders insted of 1 order per report