I have problems with left joining:
My SQL statement joins two queries using a left join.
Both of the queries are just a single table - filtered.
Both of the tables are linked from a SQL Server.

I have a table which is in the form of a cross tab in the form:
heading0      1       2      3       4
record1        a       b      c       d
record2        a2     b2     c2     d2

Hi to all,
 I just want to ask if you can give me suggestions on how can i control my
access programs/database. Im planning to do some versioning with this. But I
just dont know how to start.

I want to update a customers table "print check box yes/no" based off of a
query.  I cannot use an update query because this query needs to have an
option to decide at run-time whether to print or not.  If I created a form it
would be based off of the same query so that remains ...

I am trying to run a query to exclude 8 counties in the county field - can
only get it to exclude one.  What am I doing wrong?

I am using Access 2000 and trying to execute the following query.
SELECT x0.*
FROM qryRetainedBase AS x0
WHERE (((x0.TransactionId) In (SELECT TOP 2 x1.TransactionId

  I have a table with 5 fields containing random numbers as values (sort of
like the lotto).  is there a way to have a query to show the frequency of the
values of each fields?
e.g.

I have a database of students in field placements.  A student may have one or
two placements a quarter.  I want to run a query that will show me all the
student who are doing a placement in columbus.  The problem is, I have both
placements on the same table, and now I want the ...

Im just learing about queries and have so far added 1 table to query and used
Is Not Null statment to stop records showing without the contact ID value in
the column 'ContactID. When I add another table with more data needed to
create a report I want to do it seems to repeat the ...

I have the following text field in my query grid:
fieldname = AID
value          = svf0-12-A31 (this is an example)
(sometimes they have the A, sometimes they don't)

I created a very simple query that consists of two tables. Even though there
are matches in the two tables, the query does not retrieve them. The tables
were imported from Excel spreadsheets and both fields I'm trying to match are
text, even though they contain all numberic data. ...

I have a query with fields such as sales reps, supervisors and managers and
their sales figures. The query has to be able to give sales figures for
individual sales reps, supervisors, managers. I am using parameter query for
this. I have built a parameter for each field: sales ...

This is probably a simple question, but I am drawing a blank right now.
I would like to store the results of the sum and count functions in a query
of one table to a seperate table for further manipulation.  
How do I do this?

    I need to track equipment settings and changes for our plant.  Each
piece of equipment will have several setups, and each setup will have 28
different settings.  Right now I have a table for all the equipment with an
ID, description and a few other fields.  A also have a ...

I have a select query with totals as folllows:  group on order number and sum
three fields.  See below for detail rows.  
order    quantity    qtyship    EXTPRICE
12345    -1    -1    -312.4