query search

[Guest]

I have a table with 2 fields labeled "referenceno" and "referenceno2" and am
using a query to pull data from the table. The query is asking the user to
enter the reference # and it's only pulling half the data. This particular
problem has a reference # of 081207A and 081207B under the referenceno. When
I run the query and the user enters 081207A it works pulling the 10 records
asked for and if the user enters 081207B it works pulling the 10 records
asked for. What I need the user to do is enter 081207A and 081207B so it
pulls all 20 records when the query is run. How do I set the query up for
this to happen and how does the user enter the information.

 

[Jeff Boyce]

Already responded to in another newsgroup.

Posting the same question in more than one group means you have to look in
multiple groups to see if it's been answered.

And the folks who volunteer their time here in the groups end up duplicating
each other's efforts, reducing the time they have to help others.

Regards

Jeff Boyce
Microsoft Office/Access MVP