Query Problem

[lm0304]

I have a report that asks the user to type in a "customer" to run this report for. If the database has customer "XYZ", "XYZ International" and XYZ Corporation, how and where do I tell Access that if the user types in just XYZ as the customer to run the report for to pull ALL XYZ customers (e.g. XYZ*).

Thanks in advance to anyone who can help.

 

[mdthornton]

If you're doing this via a paramter query you almost answered your own question....

In the criteria line for customer column you probably have:

[Enter customer: ]

Replace with:

like [Enter customer: ] + "*"

or:

like "*" + [Enter customer: ] + "*"

if you want to match, eg XYZ, anywhere in the customer name. Good Luck,
Mike T