select *
from a, b, c, d, e
where a.id = b.id
and a.id = c.id

I have a series of 8 tables that I need to link together to create one large
table.  I am curious what the quickest way to do this is.  Is it better to
link all of them together in 1 query or to do a step by step progress where
is link 4 together into 1 table and 4 together into ...

Here are the fields the i have
AccountNumber     X00000
Name                    Joe Smith
ContributionMay     $4,548.24

I have imported data into a new table from another SQL-database via ODBC
databases and DSN.
Is it possible to reread the data from the extern database automatically or
do I have to import all external data again and again? Is it possible to do

I have a table worth of data with Surnames in it, and some of the surnames
are suffixed by various endings such as:
Smith(VERIFIER)
Jones(MODEL)

I have a query that includes a date field in its output. I have a check box
on a form where the user can choose whether to include blank (null) dates or
not in the output. If they tick the box nulls should be included. However I
cannot get the following criteria expression to ...

I added a condition to the WHERE clause of a query that does not limit the
number of records returned and saw the execution time of the query decrease
dramatically.  What's going on?
The query returns a little over a half million records from a database that

This Query will work as QUERY6 in the form and in the query window, but when
I take the code and put it into the record source of a form I get a syntax
error in from clause.  I tried the sub query with and without ().  Same
result.  Can someone help?

I had a report that grouped contract data by Dept - at the beginning of each
group, I had a textbox which contained the count of that group - the number
of items.  My boss decided that they don't want the contracts grouped, but
still want the group totals to show in the report ...

I have a field that contains a ten character ID.
How can I find all fields who's ID contains a blank space anywhere in the
field.
Many thanks in advance, Garry

I have a personnel database and a qualification database.  Personnel can
qualify mulitple times per year at an event.  I wish to build a query that
only pulls the latest qualification based on date.  I have tried to use the
Max function but it still pulls multiple records if ...

I am writing a query with Unix dates as input that I need to convert to
readable dates. The application has - CvrtFromUnixTime([date]) - but ACCESS
says it's not a valid expression, yet it works in the application that
contains the file?!?

My first post so please go easy...any help gratefully received.
I have an Employee Training database, and need to run a query to show
all employees who haven't done a particular course.
I have the following tables:

I have an Access database that imports a comma-delimited text file that has a
field that contains a list of URLs that are comma seperated (the array).
Example:
stock_number,image-urls

Thanks in advance for any assistance.  I have a db that tracks certain
projects.  Each project has a particular phase (phase 1, phase 2, phase 3,
phase 4) of completion as well a project $ estimate.  I need a form based on
a query Im guessing that will produce a summary of the ...