I have a scenario where an item is reserved for a project when the item is
used up it has to be updated to a free status so that it can be used by other
projects.
With the help of the group i was able to update the table and move data of

In access table "class 1", query design, for a field expression:
lookup in Table "class spelling" the field [ggwareaname] and match the value
that corresponds to "class 1" field [ggwareaname1] and return the value in
table "class spelling"  field [ggwareanum]

I have two tables. Both tables have a column named airplane_id. I want to
select those records in the first table with airplane_id's that do not appear
in second table!
This did not work out for me:

I have the following query as the source for a combo and I am getting the
above error message.
SELECT tble_employee.Employee, tble_employee.Dept
FROM tble_employee

table 1 has 3 fields, uniqueID (primary key no duplicates), name and
specialty.
table 2 has 3 fields, uniqueID and practiceID, practiceName. The uniqueID is
linked to the uniqueID in table 1 and there are multiple entries for a single

I have a set of characters that I need to replace two of them in the center.  
The two that needs to change are always in the same positions.  How can I
change them?  For example:
1000000009557142070200000000000387010

I have two tables.  One, "Units," contains an inventory of units (primary key
is a "Unit ID") and the other, "Inspections," is a record of inspections
performed on the units (primary key is "Inspection ID" and the field also
contains the Unit ID of the unit to relate the tables ...

Is there a way if I run a query on an employees table, when it is brought
back it will list the name only once with lines of infor until another group
is found Example of the query return:
Doe, John        1        1          

I tried to update a connected SQL Server Table (with ODBC) in Access 2003.
Like this --> I need the last day of the month in this table.
UPDATE tblTime
SET

Simply put, we have a table of order transactions, 'tblOrderTrans' -
it currently contains 6 months worth of data. This table is also
linked with two other tables, 'tblContact' and 'tblAccount'
What we want to be able to do is to do calculations on the average

I need to extract data where the date field (it_date) is within 2 years of
today's date.
The it_date field only shows dates as the last day of the relevant month,
i.e. 31/01, 28/02, 31/03, 30/04, etc.  If today is 09/10/2007, I would want

I am trying to combine and sum 2 or more fields from a related (child table).
I have tried
Sundries: Sum([PurchaseInvoices.Sundry])+Sum([PurchaseInvoices.Disposable])
and

I have a table (tblPrices) which contains the following fields:
Manufacturer, SoldPrice, OrderID
What I want is a query to return the 5 highest SoldPrices for each
Manufacturer.  I have tried the suggested sql in Allen Browne's website but

I am working on a report that lists the dates of classes which students have
taken, the name of the class, and other vital information regarding the
student.
I now have been requested to come up with a report that lists the dates

I have a table that has golf scores from several different players. They
don't always play each week. What I need to query is the last time (date)
each player played.