I have a table that stores [Unit ID] and [Inspection ID].  The table should
only have one instance of each [Unit ID]. The [Inspection ID] field is an
autonumber field. For every duplicate I would like to remove the older record
(the one having the smaller [Inspection ID].  This ...

I have a query the runs off a form that that has 5 different fields.  How do
I set it up so the query only pulls data that matches all the paramaters?
For example, I want to find people have a salary above $40,000 AND a rating
above 4.  If I run now it shows eveyone that has a ...

I have a DB of rates.  The rates change.  Therefore they have effective
dates.  I want to pull the Max effective date that is less than the Freight
Tender date.  I have included the SQL below for your reference.
SELECT qryGetBasePerContainer.[Broker Ref #], Max(tblOcean ...

You'll probably get this one right away...
I have a table with 66000 rows. 57000 rows have a Proj# column that is of
the form "C00000". Three rows have spurious stuff in the Proj# column like
"Total" and "Report Run...." 9,000 or so rows have a null in that column.

I have a table with about 10 fields. Sometime, user input duplicate records.
I would like to create a query or macro to find the duplicate records based
on same information on all the fields, then either copy those to another
table or delete them.

I'm trying to design a database that will track my bank accounts and credit
cards.  Thus far, everything works, except for my "Current Balance" queries.
I've designed the queries to sum each amount, and then set up a field for
Balance using the Expression:

Hi - I have a query that I would like to use multiple times within a single
report.  In each case I want to use a different set of criteria for the query.
The sets of criteria inputs will be pre-defined (I don't want to require
input from the user).

I would like to have a query give me results of "what happened
yesterday'. So at 5:00am this morning, I would like a query to run and
give me results from a table of everything that happened the day
before -- from midnight  to midnight.

I would like to setup a query that feeds a report that shows
dependants. i.e. Job A is dependant on Job C, Job D and Job F to step
7 complete before it can be started.  How would I go about
accomplishing something like this?

I have a select query that asks the user several parameters such as employee
name, deduction id, last pay date, current pay date, intrest. And it returns
the correct results.  This query would run every pay period.  So that it
gives the intrest rate based on how many days between ...

I have three tables: one for individual animals, and one each for GPS & VHF
locations for each animal from it's radio collar. Each animal may have from 0
to 100,000s of locates.
I want to update the 'LastSeen' field in Individuals with the date of the

I have 2 fields, TIME1 and TIME2
TIME1 2008/04/10 16:10:46.795
TIME2 2008/04/10 16:10:46.000
I am trying to create a new field TIME3 that will do the following:

I have a table that has a field called InvoiceDate with a text format.  The
values in the field are all in the 01152007, 04212007 type of format with the
first two digits being month, the next two being day and the last four being
year.  I copied this table and created a test ...

I have tblIP which is already assigned like below:
198.188.10.1
198.188.10.2
198.188.10.4

Please help with this
OST    Ocity        Dst    Dcity        Field1         Carrier1
MI    kalamazoo     NJ    Parsippany      EC
OH    Cincin       MA    Boston         EC