I am needing to take an existing table that has one record per person and add
multiple records to a new table.  A field in the existing table indicates how
many duplicate records to add to the new table for each person in the
existing table.

In an M2M relationship between headers and quads I
wish to select the header keys  & names where the header record
contains both of two quadkeys (CKey)  from the join table, tblQuadsJoin.
I've been trying to do this with an inner join on an inner join

In Access 2003, I have a query that uses a SubDataSheet. The problem
is that the plus sign [+] selection column sometimes shows and
sometimes doesn't. In fact, it seems to alternate when I open the
query view. For example, the first time I open it, the plus won't

Access 2003
i have 4 tables that are basicly identical  
1st nine weeks, 2nd nine weeks, 3rd nine weeks and 4th nine weeks
they all 4 have the same colums  

I'm working with a query (written by another) that nests 3 IIF's into a
single expression, then performs a GROUP BY on about 12 fields, including
this expression.  The query runs fine, and modifications can be made and run
in SQL or Design view.  However, when I modify the query ...

I wanted to set up a task that would run night to open my database and having
a module that runs on open that would synchronize to all the databases.  Is
there code to do a synchronization?
Thanks.

I need to write a query (as opposed to a report) that totals records for
each month. My table has concatenated date/time fields.
I can count the total records using count(*), but all attempts at grouping
run up against a syntax error.

I have some code running on an event procedure. At one point in the code I
need to run an append query. If the data to be appended to the table
LETTERHISTORY was in another table, I would just have an append query and
DoCmd.OpenQuery "QueryName".