Multiple Search

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???
 
J

John Spencer

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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top