I have a query that has the names of employees and the dates and hrs. they
did a job, about 10,000 entries from Jan to present.  How do I make a query
total the time by month for each employee?
Thanks!

Iam using a parameter query using Between [Begin_date] and [End_date]
End_date should be inclusive - Correct?
If Yes, When my  parameter begin date is 03/28/2007 and end_date is 03/29/2007
It gives all the values from 03/28/2007 and 03/29/2007 to 03/29/1999.

I have two queries and each count like records for a certain field.   The
results of each query has a different total of records for each result.  For
example one query has 30 records and the other results in 15 records.  The
data is accurate.

This may be a silly question but...
Is it possible to make the name of a field into two lines instead of one
long line in a query?

I have searched and found some good info but nothing is working for me.  
Please help.
I have a query that has "Received Date Time and "Opened Date Time" fields.  
Each record has a parameter in it and formatting is as follows:

I have a report and am having to make 26 queries in order to get the all of
the required information, what I would like to know is if there is a way to
contain all the queries together to avoid confusion with queries for other
reports.

Any time I put more than two tables in a query, it will not
allow the addition of new records.  Are others getting
different results?

I haven't worked on Access for a few years and I was asked today to help
someone with a query to calculate Year over Year percentage changes. Here is
the current situation:
A single table has these columns (simplified) and sample data:

I have what I hope is a simple request but I am not sure on how to perform
it. I need to create a query with only two fields: Branch Number and Loan
Type.
I need to pull all the records for Branches 061, 02, 43, 88 and 33, I also

How do I count a series of books with start and end book numbers?
I have a query, qryBooks, that has a box number and a start and end value
for a series of books (100000 - 100010) 11 books.
How do I get a query to count the books in the series and return a total to

I'm searching for some help with my query. I'm making access to be my
administration program for my freelance job. I've made a table with a row
'starttime' and a row 'endtime'. Now in my query I want to calculate the
difference between these two rows. And then I want to make ...

I was wondering if someone could tell me the purpose of the Order By On Load
property for a form, report, or query. I have read through a Help topic which
says : " If you want the last-applied sort order to be automatically applied
the next time that you open the object, set the ...

Here's my challenge:
I'm processing a customer info file with your standard demographics -
first name, last name, age, address etc.
The last name appears in all of the 'last name' fields; no problem.

I want to exclude 3 or 4 variables from a particular query.  Using Not
"xx"or"yy" is fine, but when excluding more than this, query fails.  I think
the problem is that the total text characters is quite large (approx 60
characters in total, from four exclusions).  Ideas, please ?

Can you please advise what the formula would be to convert the week number
into the date of the first day of that week?  For example:
This is week 45.  The first day was Sunday, and first date of week 45 is
Nov-4-2007.