I have a mail merge to email document set up.  It reads from a very
complicated Access query.  When I first set it up, it worked perfectly.
Subsequently, when I have tried to open it, I get this error message:
"Word was unable to open the data source. "

I have merged two tables together using a union query.  The tables I have
merged are linked tables from a SQL Database and cannot be amended.
I the tables have multiple rows with the same "order no." (see example
below).  I am using the query to pick up prices on a form, however ...

I want to do a datedif for  2 date/times, one has the year in it and one
doesn't.  I'd like to only select records where the date/times are 2 minutes
or less different.  I know how to do this if I could get rid of the year in
one date field.  Any suggestions?

Where is a good site for learning some of these query or SQL methods. In the
last few days I've asked for help with a couple of queries and have gotten
methods (that worked great) I have never seen anything on.

I would like to find out if SQL in access allows a full join. I can get the
left and right to work but not the full. If it is possible please help with
the syntax. Thanks.

I have done a lot of searching before posting this question but didn't come
up with anything, so I hope you can help.
I am trying to set up a query from a table that gives me the follwoing
results:-

Hi, I have this union query and it' results are
IDInput  IDOutput    Date     Label   Inp.Quant.   Out.Quant.   Price  /*
 00                   01.01.2005   99        100                0          
8    /

I have been tearing my hair out over this query. I have the table with:
company date quantity
acme 1/1/2005 1
acme 2/1/2004 2

Hi, I hope you can help me out.
I have a form that is a quiz with the option buttons for the choice from two
answers per question.  My question is how can I determine how many correct
answers there are per test?

This doesn't work out as I would expect (starts asking for parameters, then
returns the entire database).  What's the deal?
SELECT C239.*,
[C239]![Mean]-[C239BigAggregates6]![C239AvgMean]/[C239BigAggregates6]![C239StDevMean] AS C239ZMean,

I decided to keep two separate queries in the process.  Apparently simpler
than combining.  Here they are:
This first one is C239BigAggregates.....
SELECT Avg([C239.Mean]) AS C239AvgMean,

Need help!
I have designed a simple query to add numbers in six colums then in the
forth column, I have an expression that adds them all up then divides them
by 6 to get their average. When I attempt to run the query, I get the

Hi there, I have been trying to solve the following the problem and was
wondering if anybody had a solution.
I have two tables, Table1 and Table2. Table2 is constantly changing and
is updated by the user. Both Tables share 1 common field or column.

This is my story sad but true...
Here is my DB layout imported from Excell:
CONTROL  NAME   STORE_3   STORE_4   STORE_5   STORE_6     etc.
       1          Tim            88.59        38.43           39.22        

I have a select quey(q1) as follows:
SELECT MAX(CYR) AS Y1, MAX(CMN) AS M1 FROM TABLE1
Now I am trying to create an UPDATE query(q2) like this:
UPDATE TABLE2