query will not work

[Guest]

I am having a problem getting a query to pull correctly. I have a table that
has: Associate Name, Date, Function, Subfunction, Incoming, Processed, and
Holdover. I want the query to ask for the Associate name and date.
I have gotten the query to ask for the dates (using a "Between" statement)
but it will not bring up the "Associate Name" criteria. I am using - Like
"*" & [Associate Name] & "*" - but nothing comes up.
I am using 2 combo boxes and the second combo box is filtered (with a query)
from the first, but I dont think that should any effect of the what I am
doing now.

 

[fredg]

I am having a problem getting a query to pull correctly. I have a table that
has: Associate Name, Date, Function, Subfunction, Incoming, Processed, and
Holdover. I want the query to ask for the Associate name and date.
I have gotten the query to ask for the dates (using a "Between" statement)
but it will not bring up the "Associate Name" criteria. I am using - Like
"*" & [Associate Name] & "*" - but nothing comes up.
I am using 2 combo boxes and the second combo box is filtered (with a query)
from the first, but I dont think that should any effect of the what I am
doing now.

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.