Hi i need some guidance to produce a report in MS Access 97 for all
managers that shows the number of projects in progress, on time, late
and very late.
Name    NoProject On Time      Late    Very Late

I need to query a single table over and over again and have a problem
with one of the links.
I'm using Access 2003 and the tables are MS SQL tables from our
business software.

I have a table as namely Receipt & details. these table consist morethan 50
K rows each, & I have set unique record in receipts table & details will be
allowed to have duplicates. I have a written a query by joining this two. I
have got the details which I required, But this ...

Good afternoon,
I'm preparing a query that has a particular criterion in the DEPARTMENT
field.  Rather than rewriting the query (and the 60 others that are based on
it) for the ability to leave DEPARTMENT unfiltered or filtered, I'd like to

The following is a direct copy and paste from my intranet website. (I
am printing the sql to the browser for testing purposes and the list of
dummy tasks you can see is being generated from the database
recordset).

Hello, I have a little question. I organise a workshop with 3 activities and
now I want to make a query so I can see who does what activitie at what
hour.
So for exemple:

I have two tables with the following fields:
1. Table "web_Content"
   Fields: [ContentId] > Primary Key;
              [ContentName];

My PC recently re-booted itself whilst Access 2003 was open and I seem
to have lost some queries.
When I try to copy a query and then paste it back with another name
(so that I can change it so that it works for a slightly different set

I have a query that gets all the data on peoples hours worked.  Following is
the SQL statement.
SELECT Rep.LastName, Rep.FirstName, Cosmo.StoreNumber,
Cosmo.CallStartDateTime, Cosmo.CallEndDateTime, Cosmo.Hours,

There appears to be a table in my database (Access 2003) which is formed
through a make table query. Is there any way to find out which query/queries
made it? The dependencies don't show the information and there are hundreds
of queries to go through.

Hello everyone, I'm pretty new to Access and i have a little situation.
I want to view the Query result from a form
How do I set up the query or form that:
If No Conditions met, display all selected records

Is it possible to see the total of a column on the display screen of a query?
If so, how do you accomplish this?

Is it possible to set criteria for a "calculated field" in a select
query? When I try it I get an input box of sorts asking for me to input
values for some other field used in the "calculation".
Please advise.

I have three tables that I need joined and still be able to edit the data in
a query.
The primary table has the joining field as the key field and the other
secondary tables are autonumbered key fields with the joining field as a

I have a query and form that joins a one-to-many from two tables.  In one
table I have a field "Item Type" and the options are "Emergency" or
"Permanent" as well as a "Item Amount" field.  In the second table I have
three fields "Emergency Total",  "Permanent Total" and "Total".  ...