I have one table (Detail) and one query (AGE), i need a query to combine the
data of Detail and Age, as shown below.
Detail table looks like below
Name   TOTAL AMT

I need to move data from Table 1 to Table 2 and can't figure out how to do
it. Perhaps someone can help me.
Table 1: has 3 fields
DealerID    Car       Color

In Access, on a QBE Grid, what can i put in Critera in order to find a
Question Mark  in a text field.  The question mark is not the only thing in
the field.  ex.  Doe ?
skyking@enter.net

Guys, just back to Access after some time away (and I wasn't much good the
first time...)
I am seeing bizarre problems with a subquery.
1) I am joining two tables of user account data on a "User id" field. The

From a table with :
P_Code          P_Name            Q_receved    
 ID_1                A                         3
 ID_2                B                         5

I need to move data from Table 1 to Table 2 and can't figure out how to do
it. Perhaps someone can help me.
Table 1: has 3 fields
DealerID    Car       Color

We have product numbers that are about 12-13 digits long. I An example would
be A45643-10243.  There are a small handful that have an R in the seventh
character (i.e. A51243R-10234).  I want to exclude all products that have an
R in the seventh from the left spot.  How do I do ...

Our SKUs consist of a 2-3 digit pattern#, a dash ("-") delimeter, a 2-3 digit
suffix and 1-2 alphabetical characters (A-Z) representing a color (if one
exists). Examples:
No Color

My tblPeople table has a unique ID, people's names, and address. The
tblContrib table has a unique ID for each contribution, the date of the
contribution (which is unique for a given date and person's ID), the ID from
the tblPeople table, and other fields. Being that one person ...

I have the follow query:
SELECT Schools.SchoolName, BackupTracking.ServerName,
SchoolServers.ServerID, BackupTracking.BackupStatus,
BackupTracking.Date

I have 4 tables : budget, sales, buyings and other expenses. They all have
two fields in common : name of the restaurant and the type of expenses. I
would like to build a report that shows me, by type of expenses and then by
restaurant, the budget and the real values for each ...

I had several queries that worked fine. Somehow all the queries got changed
by Access to have As Expr1... As Expr2 etc. for every column in every query.
This has caused a web page to fail that was relying on the column names.
Does anyone know what would cause this to happen?

I need to perform inserts and deletes in several tables of my MDB in a form.
I'm using the command DoCmd.RunSQL = "..."
But i have a problem: when a do a delete statement, appears the mesage: "You
are going to delete x records... bla, bla. bla";

I have two tables:
taProperty
fldPropertyID PK
fldPropertyAddress

I am quite proficient with Excel, but relatively new to Access.  I suspect
there is an easy way to use an update query to get Access to delete an entire
row if a certain column has blanks, but I don't know how to do this.  The
reason for this is that some numbers are ...