I need to join 4 tables R, S, C and X. I need an equi join between R and X
and a left join between R and S and R and C. None of my many SQL books give
the syntax for this. Anyone know the SQL syntax?
I have something that partially works but when the join column in table C is

I am trying to create a query with a criteria that will allow for multiple
values. The field in the table is "state" and the query I want will allow for
multiple states to be selected. Many thanks, John

This is a very simple query to select all fields for a specific recor
identified with two parameters.  The query selects the correct record
however the dialog in the pop-up window that asks for the parameter
is goofy.  Where it should say, "Enter field1 value" it show

I have a query that produces a table of Part-Date-Quantity&Date, telling me
how many of that part has been ordered for date x, with the likelihood of
several records for each part.
With a second query, I have to concatenate the Quantity&Date values for each

i am trying to make a form to just run through records, but i dont want those
default buttons at the bottom of the window,  as i am taking care of the
buttons myself...  is there a way to take that bottom toolbar off?

They say that persistence pays off!
I have tried asking this question before AND I have seen posts from others
asking what I believe is the same question, but neither I nor other people
have received a satisfactory answer. So let me try again…..

I am reading a single record in my table and then want to update this
record.  How would I do this?
vSql = "select * from tbImport"
Set db = CurrentDb()

I have a table (tbl_Owner_Info) with fields "First_Name" and "Last_Name"
that are linked via combo box to 2 other tables (lul_First_Names and
lul_Last_Names), which now have about 450 first & 300 last names.  The
reason that I'm doing it this way is to assist the user in getting the

Any suggestions on how to speed up this query?  As it is, it take about 3-5
minutes to run.
SELECT MissingByColumn.tag, MissingByColumn.Fix
FROM MissingByColumn LEFT JOIN [Define Columns] ON MissingByColumn.Fix =

Hello I'm trying to create a query with A JOIN clause that is using LIKE.
The problem :
In table A I have international phoned numbers like this :
Col1

Is it possible to save a query as a table, either in the same or a diofferent
database?

Is it possible to save a query as a table, either in the same or a different
database?

I want to delete all records in a table with a field called MoldID with <  5
characters. Is this possible?

Hello.  I have a table in which i need to make a query that excludes records
if one of the columns is equal to one of two values.  I have made the query,
and it does some strange things.  The query was built in the query design
window.

I created a function in a module in access 2002.  How I can call this
function in one querie? Thank you