How to "filter" reports to show Specefic Customers Orders ??

[Will]

Can I create a "General Report" on my Customers Query

1 - Such that when the report opens it only shows one customers orders?
2 - Ask the user to enter the first letter or few letters of the Customers
Name?

I know I can put this in the Query and then build the Report on that...

I wanted to use an existing Query and not create a custom query for the
Report...

So, the question is can I enter an "Expression" in the Reports Customer
Field so the "Filtering" is done by the report?

If so, how does such an Expression Look?

Customer = "Family Cleaners"

or what?

Thanks for all the help folks.

Will

 

[Brendan Reynolds]

There are various ways of filtering reports. At the simplest level, you can
base the report on a parameter query, something like ...

SELECT * FROM CustomerQuery WHERE CustomerID = [Enter Customer ID];

This will prompt the user to enter a customer ID when the report is opened,
and will display only records matching the entered customer ID.