I have two tables.  One has all fields complete.  The other has some
complete records, but most only have one field completed.  I want to
input the complete records to the incomplete table, merging any
records that would be duplicated.

what's the exact syntax in Access for the following meta sql:
UPDATE TABLEA
SET     b = TABLEB.b1,
c = TABLEB.c1,

I am new to Access and am trying to get query information on averages.  i
created a data base with a date field, followed by several product fields
showing quantity.  I used the query wizard to get YTD averages.  How do I
query a fixed weekly average from the data base? As enter ...

I am attempting to formulate a QBF based on the instructions provided by the
following link:
http://support.microsoft.com/default.aspx/kb/209645/
However, I am attemping this with a form that has 20 areas for criteria.

I have a table which has the following structure:
SELECT PedigreeTable.DOG_ID, PedigreeTable.NAME, PedigreeTable.Level,
PedigreeTable.S_SIRE_ID, PedigreeTable.S_SNAME, PedigreeTable.S_DAME_ID,
PedigreeTable.S_DNAME, PedigreeTable.D_SIRE_ID, PedigreeTable.D_SNAME,

i would like to ask if we can delete more than 1 tables in one query
in Access?
It would be something like
Delete * From tableA; Delete * From tableB;

Old value and new value are different stops of a work flow and I am trying to
determine how long it the object takes at each stop. The following is a
reqport from the invoice system
Date                 Action    Object                  Old Value    New Value

I have a table that lists down a persons qualifications. That person has the
qualification "Yes" by a tick box.
I wish to run a report listing out all his/her qualifications. I have been
using "True" in the criteria portiion of the setup screen but have run out of

I am trying to run a query of all addresses with the street name of Maum.

I have a table where each record has a resolution date ranging from 1/1/2006
thru 12/31/2006.  If I do the followingin the res date field:  Between
#1/1/2006# And #3/31/2006#, it will show me all records where the resolution
date is in that range.  If I do the following in the res ...

Trying to count the number of Workdays only between 2 dates. [Startdate] &
[Enddate] can anyone help please.
Cheers
Sarah

I know how to add the column heading Jan - Dec if you are querying for one
year, but I have a query where a user can type in more than one year, for
example, 1/1/05 beginning date and 12/31/06 ending date.  My crosstab results
are Apr/05, Apr/06, Aug/05, Aug/06, etc.  How do I ...

I have a query that makes a table called products.  One of the fields is
called price and another is PN.  I can I create an if statement in the
criteria that would multiple price by 2 if PN starts with the letter X?
Something like this:

I get stuck on this every time. . .  I have a totals query and I need to
include a column to sort by that is not shown in the query results.  How do I
add that column without having to group by, which messes up the query?  I
have Last in the Total row of the design grid, which ...

I have a database (Micro. 2000) I created that has all my subcontractor
information in.  IE: adds, names, etc but the important part is the
certificates I'm required to have by law to have and they expire- I’m trying
to get the right expression for a query that the criteria will ...