Strange Search Query

[Dougalsworld]

Hi all,

I have 2 tables, tblCustomers & tblPriceChangeAuth.

The database is for auditing purposes where by we have to be able to trace any price changes we make. The problem is as follow's:
tblCustomers
CustomerCode e.g. 1000001
CustomerName e.g. Joe Bloggs DIY
PossibleCat1 e.g. All Independants
PossibleCat2 e.g. All Customers

The Problem is that a price change may be logged againts a customers name e.g. Joe Bloggs DIY (single Customer), alternatively it could be logged as an "Independent Customer" (multiplie customers) or it could be logged against "All Customers"

I basically want to be able to put in a customer code and a date and have the form bring back all the results of price changes that were effective on that date (all price changes have a start and end date) using the other 3 fields as the parameter.
i.e. It would return all results for "Joe Bloggs DIY" all results for "All Independants" and all results for "All Customers" is this possibe?

Thanks