I'm joining two tables together in a Form as a Datasheet View, but I'm
stuck on a query that won't return all records.  Here are my 2 tables:
customers (Table 1):
- customer_id (auto number, PK)

Hi - I am using Access 2003 -
I have two client databases which are suppose to be identical except 46
clients were not placed on one of them. I wanted to see if there was a query
which would compare both lists and only bring out the 46 from the bigger list

Hi, I have a query with an expression field that calculates the number
of days late by subtracting the due date from the completion date.
This of course means that if a task was completed on-time, the number
will be negative.  Since I want to display both late and on-time tasks,

I am building a commission db.  I am trying to write query that returns the
payout percentage given 2 variables; revenue and pullthrough percentage.
Here is a sample payout table:
Revenue   Pullthru    Payout%

It's been a while since I used access and need a refresher.  
I have 2 tables.  One lists all the customers who called in on sept 8.  The
second lists the customers who called in on sept 8 because of one specific
product.   How do I set up a query to show the percentage of ...

All,
 I would like to have a query with a correlated subquery that will
give me the records associated with the minimum of a calculated value.
I am calculating the difference between the depth in one table

My data looks like this when it arrives into my tables (queries)...
Start Date       End Date      Initial Rate    3rd Contract    4th      5th
11/20/2001   12/25/2001       4.5                   
11/20/2001   11/30/2004       3.6                   

I am looking for help building an efficient query that can return the daily
costs for my employees. I have a table with my employee names and their IDs,
and another one with the daily hours worked by each employee, and finally
another table that contains the hourly rates for my ...

I have a query that is very slow, 5minutes+ to run when I have any of the
fields prompted for information.  If I type in the criteria in the Criteria
Field the report runs in about 3 seconds or less.  I am using [FN] as the
prompt.  Why would this be happening.

I am trying to run the following (update) pass through Query and I am getting
the following error:
ODBC-call failed
[Microsoft-ODBC SQL Server Driver][SQL Server]line1:incorrect syntax near '('.

I wrote the following IIF statemeent:  url: IIf(IsNull([domainname]),[link] &
[foldername],[domainname])
domainname is a text field with http://www.something.com
link simply shows http://www.graphicfreak.com/ 

I have a query looking like this :
Name.....Score.....Tested.....Date Due
Bob........87%.....05-FEB-02..05-FEB-03
Steve......62%.....03-JUN-03..03-DEC-03

I am really new to ACCESS and am needing to find the latest transaction of
each product (PRODNO) for each Purchase Order (PO) in my Table named MMTRAN.  
This table has fields of PO number (PONO), Product number that is purchased
(PRODNO) and the Transaction Time (TRANTIME).  ...

table: users
columns: owner, admin, user
Query: create a fourth column called type when,
admin = 'y' insert a "3"

Good evening (at least here in South Africa) - could somebody please assist
with the structure for update queries. I am trying to accumulate two totals
in a 3rd file from data out of two other files.
File 1: tblLoanTrans