Search query

[Richard M]

I am looking for help in setting up a search query. I
have 12 tables in my database that I have 21-25 fields
all the tables have 18 fields that are the same in each
table. I have 9 fields that I want to display from a
search but use 3 fields as my search criteria [Equip_ID],
[Merchandise_ID],[Account_No]. What is the best way to
set up my query to do this task?
Thank you for the help

 

[[MVP] S. Clark]

Why do all 12 tables have the same 18 fields? Can you combine the info into
one for Reporting purposes? If not, then you can use a UNION to work around
it.

The best way to set up the query process is to create a form that accepts
the user input. From there, create a SQL string in code that returns the
desired results. Depending on whether you use a subform, another main form,
or a report, will dictate what other steps will be needed to trigger the
population.(i.e. recordsource, filter, or where parameter.)

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-