I have a table that has ten columns of simular information.  I need to
combine the information and group it.  What is the best way for me to
do this?

(Access 2002)
I have a select query that shows jobs that we need to inspect. One of the
columns is to add a check mark upon inspection. Unfortunately, I can not
change or add and data or check marks within this query. The only problem I

This query hangs in the middle of executing. Can anybody see or explain
what's wrong, please?
INSERT INTO HIPlanNames
SELECT [2004_HiPlanNames_ADD].*

How can I query a date field to show a rolling year from today?  Thanks much.

I set up a Combo Box to do a find on my form so I could pull up certain
records to update.  It was working at one time now it will not work.  What
have I done to make it stop working?????

Hello again.
I have a table "Timesheets" where a timesheet is entered for an employee
each day, including days not worked. A pay period is 14 days. I am trying to
query by employee ID where # of timesheets entered <>14 between  beginning

I am trying to create query that will give a running counter and restart it
when the value in a field changes.
E1A3001  
E1B3001  

Is there something special I have to set up  norder for an update query to
add and records that it does not find a Primary Key match for.
Example: If T2 has an Employee ID number not found in T1(e.i. a new
employee), the update query will add that records information to T1.

This query hangs in the middle of executing...It's fairly simple, and I
cannot see what's wrong with it. Please help !!!!
INSERT INTO HIPlanNames
SELECT [2004_HiPlanNames_ADD].*

I have an Excel table linked to Access.  I can use that table in a query -
but.. I can't update the Excel table with an Access query.  I have done this
many times before.  Is there something in the set-up I need to change

I receive a file which has the Date field in a number format as follows:
2032006 (3rd February 2006) or
12082005 (8th February 2005)
I currently use the following formulas to break these dates down and then

Howdy from Oklahoma!!
I am new to ACCESS and needing help with a Query.
I am having a problem with a query that is performing an addition function
of 4 other fields.  As in Sum1: Q1 + Q2 + Q3 + Q4.  (where each Q# is an

I am using this:
SELECT T1.*

My data looks like so:
Date    Identifier    Type    Volume
20060302    611654    A    22
20060302    611654    A    22

I have 3 tables X, Y, and Z. X and Y are linked by fields of type Text
(A and B respectively). Y is related to Z by a field of type Numeric
(C).
I need to JOIN these fields to relate X to Z. Is it possible to