i'm trying to find the total revenue for each of my employees
right now the query lists each employee hundreds of times for each
transaction they make
how do i get access to add the all the fields which hold the sales amount

The following is a module I use to calculate time.  I use the following
string in my reports. But now I need to know how to Add all the calculated
time to show manpower per report not just a record.
String:

Looking for a quick formula that I cannot seem to figure out. I have a
database of my time, on a week ending basis.
Table includes:
RecordID

I've created a database with some one-to many relationships.
One table has some "generic sample data" (name, manufacturer, type) It
is organized in bacthes (name manufaturer and type will always be a
unique combination) . it is connected to another table that holds only

I am trying to convert seconds to hh:mm:ss
Below is what I have and it doesn't work. Any help is appreciated.
TTime: (([TSeconds]\3600) Mod 24)) & ":"&
((TSeconds] \ 60) Mod 60) & ":" &

When I only want to chosse one criteria in a parameter query it works well,
but somtimes I would like to leave the Parameter Query blank so I can see
all the data rather than filter it? Is that possible.
Other times I might like to see two of the possible four criteria. Is there

I would like to remove rows based on duplicate recoreds in one column.  see
table below.
KEY            DETAIL1     DETAIL2
X1                 A               F

Can a single specific record based on two different fields "school" and "date
of action" be opened in a REPORT using a command button?
The DB in question is to be used by non technicals and I need make it as
simple as possible.  One finger click to get the exact record they need.  ...

My query currently displays 2 colums and 6 rows, as below.
    NAME    SUBJECT
-------------------------------------
Row1    Alan    Maths

i m new user to ms access can u please tell me in detail how to make a
parameter query , how it works
supposr i have employee table and i wan to c each employee for a particular
manager , and every tine i run the query it asks me for the manager id, and

Hi,  I have a table with the following fields (and formats):
Model (text format)
RegPlate (text format)
Mileage(number)

Hi folks... coming from regular SQL and Oracle, i wonderd if you could help
me on how to accomplish the following task in ms access. Thanks a lot in
advance for that!
Here is the table structure:

I have created fairly large table to gather hospital audit information.  The
audit has 70 questions per unit.  The questions have a Yes, No or N/A value.  
I need to create a report that will give me only the No values.  Creating a
query with No in the criteria is not going to ...

I am creating a query which is a combination of two tables (contains fields
from both Table A and Table B).  Though I now don't specify any criteria in
the query design view, the query will display form me only the records where
there is an entry in any one of the fields in Table ...

I want to create a new field (DBE/SBE Goal) in a query based on information
in existing fields (DBE % & SBE %).
How do I write the expression to get the following result: If there is a
figure in the DBE % field, give me that figure followed by "% DBE" and/or if