Multiple Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

New to programming access and i am having difficulty trying to get the
database to work the way i need it. Can anyone help???

What i am trying to accomplish is a pricelist that advises sales people of
alternative products available, this i have managed.

When searching for products from Table 1 to Table 2 i have a relationship
between the oem part number and reman part number.

When i search for products that do not have an oem number as they are made
by the reman company only, i get no results.

How would i change the code to allow me to search for the reman numbers as
well as the oem???
 
Probably all you need to do is to change the JOIN between the tables.

Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top