Hi all,
My users need a report of customers who shop a certain brand. They need the report to return all customers with that brand in any of 5 fields. I'm trying to give them a drop-down box instead of a parameter query to make it easier for them.
My table has these fields:
Cust
Brand 1
Brand 2
Brand 3
Brand 4
Brand 5.
For example, suppose they want a list of customers with "Chanel" in any of the 5 fields. Can I give them a drop-down list of brands to select from, including Chanel, from another table?
Thanks so much,
Sarah
My users need a report of customers who shop a certain brand. They need the report to return all customers with that brand in any of 5 fields. I'm trying to give them a drop-down box instead of a parameter query to make it easier for them.
My table has these fields:
Cust
Brand 1
Brand 2
Brand 3
Brand 4
Brand 5.
For example, suppose they want a list of customers with "Chanel" in any of the 5 fields. Can I give them a drop-down list of brands to select from, including Chanel, from another table?
Thanks so much,
Sarah