I'm trying to develop an aggregate query for a table to summarize sales.  I"m
using Design View, selecting my table, clicking close, then double clicking
what fields I need.  I'm having it show totals and selecting group by, then
I"m typing in expressions, too, and having them ...

I have a trial balance master table (TB Master) with the following
fields:
    Period (text, YYMM format)
    CoNo

Each job has a variable number of consultants (ranging from 0 to 5)
The names and addresses of these  consultants have to be printed out across
the bottom of a report, in a variable number of columns depending on how many
there are for the job.

I need to trim some reference numbers in the form of
B D AAA
D A BCD etc
too

Could anybody please instruct me on how to format a field in a SQL UNION
query?  My SQL statement is like the following:
SELECT
#1/1/2005# As Period,Q_UNION_AR&Sales1.*

I am using Access 2000.   Can a query be created that generates a temporary
table, and then
a report uses that temp table for input ?  How about a query working on the
generated temp table ?

I have created a cross table query and exported the results manually to
the other table.
Can any one please help me to write a cross table query which will
automatically store the results in a new table.

I have a table with the following fields:
PlanID
PlanName
LOM

I have a form with an underlying query for data input.  It is brought up by
entering the primary key in a search parameter box.  All works fine, except
when changing certain field details and then entering or tabbing to the next,
it resets the primary key to zero. The user then ...

Trying to find out how to Query a field that doesn't contain any characters,
alpha or numeric.
I'm using 'Like "*"' for find records that do contain characters but stuck
on how to find ones that don't.

I have 2 tables that have common structure.  Both have 2 colums, (1) Account
Title
(2) Amount.
I want to sum the Amount colums of the 2 tables.  How will i do that.  Thanks.

I have a databse with a customer table and three seperate account tables all
linked by CustID.
Each account table contains a field called profit.  I am trying to use an
update query (I havle a blank profit field on the customer table) to

I am trying to set up a query with a calculated field (let's call it
[NoticeDate]) that contains a number of conditions.
The query includes the following fields: [CurrentTermExp], [30Days'Notice],
[60Days'Notice], [90Days'Notice]

Hello - Sorry for the double posting
I am using Access 2002 and I need some help on my query.  I have a field
name "claim examiners", which I use the first name initial and the last name
initial of the examiners name.  For example Janet Jordan the field will be

All of my records should have a unique ID (imported from a text file so
it's NOT a key).  I am looking for duplicate ID#'s
My select should look something like:
SELECT Last, First, ID from Student_List where count(id) > 1 Group by ID