I have a query where I would like for all employee records to display for
time taken.  If the employee has not taken any time off, the record should
show "0".  Here is my query:
SELECT tblEmployeeTimeOff2.Instructor, Sum(Nz([Hours Taken],0)) AS [Hrs

I need to be able to join data that is similar though not exact.  The data is
street address - some of the recoreds are Street vs St, some are 125 Main St
vs 125 Main.  I know it won't be perfect but I was hoping to gain more
matches - is there any way that this can be done?

I have query table wherein it has some calaulated fields. Some of it  as
follow_
Tonnage  Length  FromSta  ToSta
 500         400       1200       1600

i'm running office 2007 and have run into a strange problem.
i have a query which has 2 fields. 1 is a unique ref number where each
number appears more than once and the other is a date field which is used for
criterea.

I have a table like this in my db:
id number amount
X-0006 3 65
X-0054 2 678

In an MS Access database, I have a table that keeps the history of
some user actions.
I need to implement a mechanism to keep the number of entries in this
table to a decent value.

Good afternoon,
I am having trouble w/ a query. I set up a query w/ the following code:
SELECT [A-GATotalInventory].Date, [A-GATotalInventory].UnitAssociate, [A-
GATotalInventory].Manager, [A-GATotalInventory].Name, Count([A-

Good afternoon,
I need help on finding out how to run three different counts on one query. I
have a table set up to show Date
Within this query I have the following fields:

I have my query prompt the user for entry. [USER INPUT] I want to all them to
enter data, but if left blank I'd like it to show all data. How would I
change the criteria?
Thanks

I have an Access Database 2000 to track performance. Within the db I have a
performance table where user input their ID, date, part#, start sequence &
stop sequence daily (there can be two entries per day). Then on another table
with field: part#, sequence#, time (min).

Good afternoon from Sydney.
I need help with a problem here.
We have an access database supporting the work in the office. there are
several reports, forms and querys generated.

any help/advice is much appreciated....  let me explain...
 i have this table w/c have multiple date/time fields... corresponding to
birthdays of people.  a single record of a person contains his birthday, his
spouse's name & birthday, and also his sons/daughters names & ...

I'd like to build a query to cumulative total. For example
EmployeeID  Amount
A                  $10
A                  $20

I have a database that was just imported that has approximately 388000
records.  The problem is that there is information about a person in multiple
different records but the name did not come across with each record.  (So I
have 10 records with information for a certain name, ...

I have built a database and have built the tables from Excel spreadsheets. I
did not use link for some work-related reasons, I simply Imported the tables
and assigned primary keys. I then built my queries and forms as needed and
everything works fine. My question is, now I would ...