Have a roster that needs to deduct start time from finish time and start
break from finish break extracted from a table.
Example Start 9.00 Finish 18.00 Start break 13.00 Finish break at 13.30.
Cannot get past a result of 8.7 hours irrespective if table is in numbers or

As the solution to "filling" a crosstab, it was suggested that I use this
function.  The line is:
TRANSFORM Nz(Count(RECV.[BAND]),0) AS CountOfBAND
However, that generates some results that I just can't understand when I

I am trying writing a SQL query to pass into an Chart in access. My
problem is i need to combine 2 querys together to give me the two lines
in the chart. Using the wizards this is no problem but i want to use
sql so i can pass variables into the query to make it easily updatable

I have a query where I'm setting up fields to find between values but return
all if left blank. The between values is easy. I'm stuck on the all if left
blank part!
What do I need to add to this to make that happen:

I have the following Query that finds duplicates based on Last Name and
First Name.  I would like to be able to find duplicates based on Last Name
and the initial of First Name. Any help will be appreciated.
Jack Peyton

I have a list of about 80,000 records and i know that at least a quarter of
them are probably duplicates.   I am reasonably crtain that the telephone
number in each record is accurate, so I ran a duplicate query and found some
22000 records ( so assume that about 11,000 records ...

I am trying to create a single query where I can show the top 50
records of each category.  For instance I have 3 columns in my table
Name | State | Salary
I want to show the top 50 salaries in PA, NJ, DE, MD so a total of 200

I have a table tblTransactions: TransactID, TransactDate, DeviceID, Tabn,
...
The table determines the user (TabN) for any registered item (DeviceID) at
any time starting from date, the item was registered as used by some user.

I need to enter a criteria in a query (can do that) and then I need the
entered value returned in one of the fields returned.
My criteria is <["Please Enter Year (YYYY) ?"], hence the retuened year
won't all be the same, hence I need to return the criteria in a field to know

Access 2003.  I have a JOB DETAILS (one) table and an ADD ORDER (many) table
in a one to many relationship.  JOB DETAILS has an estimated delivery field.  
ADD ORDERS has an estimated delivery field.  I want to create a query for a
report that will be a schedule showing all JOB ...

There got two tables and I needed join them into one:
-------------------------------------------
Table1 (Master)
-------------------------------------------

I have a table that contains duplicate userids but each user id has
another set of information that is put with a priority. eg they say
their favourite colours are blue and red. blue has a high priority than
red so we say that blue is their favourite colour. i was just wondering

Access 2003.  I have a schedule query that pulls all orders from tblORDERS
and sorts them by delivery date.  I need to show the price for those orders
by calculating the total of all the related records in tblORDER DETAILS.  
Every time I try and include the ORDER DETAILS on my ...

I try to calculate the result by using left join but it still returns the
output same as using inner join.
************************************
Table1(T1)

I am trying to not display CommCheck at all if TotLavaCost = 0, but if
TotLavaCost <>0, then I want to display the result in currency format.
The following statement returns the correct, but unformatted results:
CommCheck: IIf(([TotLavaCost]=0),"",([ExtendedPrice]-[TotLavaCost]))