First I use access 2003, I am trying to create a make table Query that
will the following characteristics
             Col 1      Col 2      Col 3     Col 4                      
Col 5         Col 6

I have a database that stores information about parts that have been ticketed
as defective.  I need to make a query that will allow me to generate a report
using the following criteria:
1- a beginning and ending date range

I hope I can say this half way intelligently.  I have a record set with 2
date fields (One in date and One out date)  I have a query to select the
records between a specific date range (no problem) now problem: I need to
also select the earliest date in at the same time.  So thus ...

I have two tables to join.  T1 has the header type information and T2 has the
detail, hence the one to many.  Now I want to join the two tables in a query
and return only the entries in T1 where any one record in its detail in T2
contains a zero value:

I have a table setup tbl_Hours that tracks employees, times started
and finished, and the project number details of the work. The table,
when initially designed, went the quick and dirty way: Example of the
field list:

Can someone tell me what's wrong with my expression?  Maybe I'm using
"Now()" incorrectly.
I want to get a client's "L O S" (Length of Stay), which is usually
the difference between the Discharge Date and the Admit Date, unless

I have a Claims system where there are multiple transactions per claim. Each
of these transactions has a Transaction ID. Each Transaction now needs a
Transaction # per claim. Going forward this is not a problem but is there an
easy way to go back and update the TransactionNumber ...

I have two tables in my database.
I would like to update the information in table 1 with the information in
table 2.
I am importing information from an excel file in table 2, and depending on

I'm trying to use the WORKDAY function within a query. If the query returns a
warning box when I try to run the query that says 'Undefined function
'WORKDAY' in expression' does that mean my Access does not have that function
within it's capability? I can't work out why it's not ...

Is it possible to create a crosstab that concatenates text?  This is what I'm
trying to do:
Table 'Allergies':
CamperID, CampID, Allergy

I have tried everything to get a field in ascending order. The field is part
of a large query with 12 tables and 26 fields sorting and grouping with 4
fields. However I can not get this one field to Ascend in the correct order.
What can I do?

Example - I have dollar amounts in a table and I'm trying to make the field
name equal to the parameter value (ie <$30) in a make-table query.  So in
this example the field name would be "<$30", is this possible?

Is there a simple way to list all the Forms, Queries and report for a given
database that a field is used in. I need to change where this field currently
comes from.

I have a database that I think is crippled, the poor thing never had a
chance.  I cannot have 3 tables in any of my queries.  I think it's
because of how they are related.  This is the SQL of the query that
won't run.

Good day, I am in serious need of help here.  I have a query that has
calculated expressions and a main field called RecordNumber, what I am trying
to do is count the record number but everytime I open the totals field and
change that field to count I get the following message: