Ok I would appreciates any help I can get.
What I need is this query to be dynamic. I need it to keep adding  this (
[WFM Reps_x].[Code Number], [WFM Reps_x].[First
Name], [WFM Reps_x].[Last Name], [WFM Reps_x].level ) until it has no

Good morning,
I am working on a DB that has response data in 12 fields (resp01..resp12)
per record.  I have been asked to accum the values and a count for non-blank
(not null) fields.  I want to do this in a query.  I appreciate your input.

Hi gurus.
I would like to create a delete duplicate query that deletes a conditional
critiria. I will explain
I have a table with a few fields

When I import a query (which has 2 tables linked) into a blank interim
database and then import from the interim database into a production database
the linkage is lost. It seems that during the import (into interim) the
tables must exist in that database else you lose the links ...

I must zero fill a text field in a query but not sure how to go about it.  
Suggestions anyone?
Thanks!

ISN'T HERE JUST A "READ ONLY" PROGRAM IN POWER POINT THAT CAN BE PUT ON YOUR
HARD DRIVE TO READ A MESSAGE IN .PPS?

I have this query.  I would like it to return only 1 record that is the
oldest (most days) in the Last_Activity field.
fields are ID (PK autonumber), Login(text), Status(text), Comments(text),
Last_Activity (Date)

When I use a name such as "FTE - Total" (without the quotes) as a column name
in an Access query (using the QBE screen or SQL code) the name reverts to
"FTE-Total" (with the spaces missing) when the query is saved and reopened. I
have tried using double quotes around the name, ...

I have a query with a "with clause"  that has [enter beginning date]
I have a report that uses the query.  I need to display the value entered
by the user in a that report.
so, the report has

I have 2 tables that I want to join together into one. In tableA there is a
lot of missing data in a field that tableB has. The common field between the
tables is unique in tableB but in tableA is indexed with duplicates (very
few, but enough to warrant indexing that way)

Here is my synatx with the error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\WINNT\system32\NTS.mdb'.

I want to Query a Table using the Query builder.  I want to find certain
words and exclude them from the results.
I was told by a friend to use the following syntax.     NOT IN ("CO","CORP",
"Corporation")

I have identical table structures in two databases, one on a client side and
the other on the server side.  I want to run an asp query that will take all
of the records from the client and push them into the server db.
Is this a Insert command that I have to loop for each record, ...

I am trying to calculate the age of an item by doing the following (where
OPEN_DATE is a field in a table and DATE() is the current date):
DateDiff("d",[OPEN_DATE],[ DATE() ])
It is actually giving me the number of days difference, HOWEVER, it is

I have a table with transactions in it. Here is a rough layout:
trnum, trdate, ttype
Say their are 100 transactions between 7/01/05 and 7/31/05.  I need a report
where is shows the transactions grouped by transaction type (ttype) and at