I'm having trouble getting a COUNT() on many fields in a table.  I have
a table that records the number of times a Student was absent or late
on a given day (attendance is taken 3 times every day).  My fields look
like:

This may seem complex to explain but I will try.
This is a medical database.
In table 1 (Contacts) are all the clients and relevent details,
included in this is a key which identifies the allocated nurse. A list

I have a report with several date parameter queries.  I created a form with a
calendar for beginning date and calendar for end date.  Here is my problem:
Calendar returns a date as 12/1/2005 not as 12/01/2005. I tried formatting
the data with an expression field using mm/d/yyyy.  ...

I need to know how to have my query find the Qty used before StartDate.
And then in the next column find Qty used between StartDate and
EndDate.  All information is in one table.

I have a query of one hundred items numbered 1 to 100.  I want to select some
of them with a YES/NO field.  In a query, I select those records checked
"YES".  They are kept in order based on their number.  
Then, I want to assign a new number 1,2,3 etc. for as many records as the

How do I accept a StartDate and then add 6 days to come up with "Between
[Start Date] and <the StartDate+6>"
Will always add 6 days to the startdate.

Iv'e posted a couple of questions lately without resolving my problem.  I
need to export two tables, a main table and a details table linked to a
subdatasheet with an "accountID" PK, via excel file to my main office. My
form has a subform linked to the details table.  My first ...

I have field names with data I'm trying to pull apart.  Ex:
1234 Horse Hockey Ln 678
I'm trying to generate a query to look for "Ln", so I can strip off the last 3
characters and plug them into a separate "apartment" field.  Note that this

I have two tables with the AutoNumber as the primary key.  The AutoNumbers
are each formatted to identify the person inputing the data.  Each has a
letter followed by four digits.  For example:  K0025 and L0019.  I have
separate append queries which appends the data from each of ...

simply can't get this to work...
I have a table (Table A) containing records with about 20 different fields.
One of the fields is going to be matched with an equivalent field in another
table (Table B) using the "join" facility - so far so good.

I am updating a program.  The program uses VBA to create a query.  The
problem is that the orders.[service charge] is being generated with the TOTAL
field = "Expression".  If I go into the query design view and change the
TOTAL field to "Group by" the query works perfectly.  

I have two fields I would like to use in a form per a query. The fields are
RequestDate and POIssued. The Requestdate is a date field and the POIssued is
a Yea/No field. I would like to setup a query that will show all records that
have not been issued a PO 30 days past the ...

I have a simple question. I have a TRUE/FALSE field in one of my tables. When
I build a query and export the results to an Excel spreadsheet, that
particular field all it says is "TRUE" or "False" How can I change it to say
"YES'  or "NO" instead?

This there a way to set up a query that will clear a table.  I know I can
make a query the "makes" a table and if the table already exsist then it
deletes all the data in it.  However, this also deletes the formats of the
table, such as "Index: NO, no duplicates".  Is this a way ...

I have created an Access database of all the documents in our library. I need
to give our patrons the option to use a keyword to create a list of only the
documents that have the Keyword in the title.
Also is there a way for Access to do a keyword search inside docs? (word,