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

Multiple Field Search

P: n/a
itm
My boss has an Access 2002 db with 2 tables that each include almost
1,000,000 records. Their common demoninator is an account number. One
of the tables has 10 column fields with jurisdiction numbers. He wants
to search all 10 column fields with the result being all records and
their associated information for a specific jurisdiction number. The
jurisdiction number for an account would not be duplicated in a column
field but could be located in any one of the column fields so each
column field has to be searched for each account number until that
specific jurisdiction number is located (if it is-many of the accounts
won't even be located in the jurisdiction selected).

Now I am not an experienced sql, vba, or function writer so I consider
this completely over my head so your detailed help would be very much
appreciated!!!!!!!!!!! THANKS! Mary Ann

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
it*@itmservices.com wrote:
My boss has an Access 2002 db with 2 tables that each include almost
1,000,000 records. Their common demoninator is an account number.
One of the tables has 10 column fields with jurisdiction numbers. He
wants to search all 10 column fields with the result being all
records and their associated information for a specific jurisdiction
number. The jurisdiction number for an account would not be
duplicated in a column field but could be located in any one of the
column fields so each column field has to be searched for each
account number until that specific jurisdiction number is located (if
it is-many of the accounts won't even be located in the jurisdiction
selected).

Now I am not an experienced sql, vba, or function writer so I consider
this completely over my head so your detailed help would be very much
appreciated!!!!!!!!!!! THANKS! Mary Ann


In the query builder you put a criteria entry under each on the 10 columns
making sure that each criteria is on its own row. This produces an "OR" of
the criteria rather then an "AND". The resulting SQL is similar to...

SELECT * FROM SomeTable
WHERE Field1 = SomeValue
OR Field2 = SomeValue
OR Field3 = SomeValue
etc...

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.