Query is not doing what I need it to do.

[Guest]

I need to have a query that pulls data from a table that has 4 fields that
represent route days in a month. What I want to do is select only clients
that have lets say route day 4. I have tried using criteria and an unbound
control in a form but I keep having the same problem. I can set the criteria
to one field but when I try to set the criteria for a second or the other 3
it comes up blank. The route days are based on a 20 work day month. A client
can have up to 4 route day numbers with each one being different. All I want
to do is enter a number for the criteria and pull each instance of that
number from the table along with the client that is associated with .
If I have overlooked something really easy please excuse me and thanks for
your help.

 

[Duane Hookom]

"If I have overlooked something"... how about providing us with your table
structure and maybe a few records. I have a sneaking suspicion that your
tables might not be normalized but it is difficult to tell without seeing
your data.