I have  a query that is based on daily timesheets. I need to create another
query that will count the number of days that a person has worked for the
past 15 days.  Then I need to figure the average hrs they worked for that
time period.  I have gotten it to work with the between ...

I have a query that shows me all my suppliers, 1 of the fields shows the due
date of the item. i would like to run the query showing me all over due
orders, which are more than 2 weeks older than todays date, i don't want he
user to enter todays date but access to take todays ...

In the past I've had no problems with creating a huge expression to sum up
several fields.  All of a sudden, when I open up the query it has cut off
several of my fields in the expression.  I get of course, the syntax error
that it is missing a bracket, etc.  Makes sense because ...

I have a table for Customers and then a table for Prices. The Price table has
an autonumber field for "Price ID", but some old records have already been
deleted. (The Prices table is overly large and should be streamlined, but
that's another project.) There is also a "Report ...

I want to know how many records there are for each letter of the alphabet by
last name

When you open my parameterquery, you can type an artist in it, and then you
get a list of all tracks that artist has made.
but my problem is that, if your spelling is incorrect, you'll have no
results. So what i'd like to have is a list of options (a list of all the

Been trying to come up with a way to use a wildcard in a parameter query.  
Ex. Parameter query asks for a description, if I enter "tires", would like
the query to pull every record containing the word tire in it.

I have a union query that is actually working fine except that it keeps
repeating a field value that I would like to have display only once.  For
instance it says:
Jane Doe

I have a field that is a character field, and "0" represents 0, "  "
represents Null.  The problem is that when I use <> "0" in a query it returns
all the fields with "0".  If I use Is Null, then all fields are returned that
are not empty.  I change the field to numeric for data ...

I have created a database which captures all trades performed by the
Investment Team on a daily basis.  All the necessary tables, forms, queries
and reports have been created.
I wish to export data displayed into a report into an excel document (not

I have a query that calculates the number of hours worked, sick days
entitled, sick days used and sick days remaining.  The problem is that for
our p/t staff they get 3 paid sick days but after working 1700hrs they get an
additional 2.  I can't figure out the formula that will ...

I have a list of subscribers that are entered throughout the months.  I
would like their subscription to expire on the first day of the following
month on the following year.
Eg.  subscribe 03/24/05  - to expire 04/01/06

I have data downloaded to me on a weekly basis which I have to clean up
for my report.  
In table view in Access I run a find and replace on a field to clean up
text to the left of my "(".  For example:

I am trying to create a Delete Query to delete records in a Microsoft Access
table created after February 28th 2006.
The date format is: mm/dd/yy
Thank you, any help appreciated.

Hi I have a query is used for the control source of a report, Monthly
Statements
The query was running fine when it was simply showing all debits, now Ive
tried to adapt it by joining another table, transaction which stores details