By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

Query multiple fields

P: 1
I have a database that contains a circuit ID in two different fields. One is the old number and the other is a new number. I want one query that will look in both fields for the query, Like[Enter ID]

I don't do VB
Aug 4 '06 #1
Share this Question
Share on Google+
1 Reply

P: 16
Without using VBA here is what you can do:
If you want a query to look in two fields you need to drop down one line on the criteria. For example, in your query you put in the circuit_ID_OLD. In the criteria you put like [Enter ID for OLD] Then move to the next column and put in circuit_ID_NEW field. One line below the criteria you used for the OLD id but in the column for the new ID put like [Enter ID for NEW]

When you run the qry it will ask you for the old ID string to search. Put the data you want in there followed by the * symbol. When you press enter it will ask you for the new ID string to search. Do the same thing. What you will find is a match for either old or new and the coresponding other field ID information.

VBA would be much better though.

Aug 7 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.