Multiple Field Search

[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

[Rick Brandt]

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