Earlier this week, John Nurick helped with the answer pasted below.
I have tried everything to try to make this work, but when I get to the
part about the calculated field, I keep getting an error about an
ambiguos name in the field.

There are two fields in a table i.e. Time, Name.
I want to eliminate records where the Time difference for any record is less
than 10 seconds. This is required to overcome the problem of duplicate
entries. Please help in this regard.

I am trying to run build a querie that will give me each customer I have done
a job for, but only list them by the last date. (we may have performed the
same service numerous times for some customers.)  problem: When I run the
querie, It will list the same customer for every date ...

Is there an expression similar to Like "######" that will check for six
letters?

Hello Group,
I need to build a form with 3 drop down fields on it.  Month, Day, and Year.
I need to qry my table and look for a month or day or year.  An example,
I want to pull up records for 01/15/*, or 01/*/*.  How would I do that?

I am having some difficulties with an EOMONTH function in the query
grid. I get the "Undefined Function" message box appearing when trying
to use it. The "Help" facility says I need a specific *.dll file
installed in order to use the function. I have the specific *.dll file

We recently upgraded from Office 2000 to Office 2003.  After doing so our
string functions don't seem to work anymore.  When I attempt to run a query
that used to display the 5 rightmost characters of one field, I now get an
error message:

I have a table call 'factors' for which i wish to create a query.
The table has the following columns:
From (integer),
To (integer),

I need a single query to get a list of column names for a given table.
I know how to do it in SQL by using some system table, however, I have
no idea how to do it in Access?
Thanks.

I need to query a table of dates that each have multiple appointment times
get the first appointment time for each day in the date range.  any
suggestions?

I have a table which has a field called "Center Codes" and another
table with the same filed name. In order for these two fields to match,
I believe I need to update the original table by adding three numbers
in from of each record that has information in it (not all records have

There are two parts to my question:
Firstly I have created a parameter query which asks for an insitution
code, then brings forward the contact details for that insitution.
This query works fine except the prompt box pops up twice before

Private Sub cmdAdd_Click()
Dim updatesql As String
Dim Updated_Allowance As Currency
Updated_Allowance = Forms!frmadjustallowance.CurAllowance +

I am using Access 2000
I have two DBs with test records and 1 Db with Employee inform.  They are
all tied together with an ID number for the employee.  I want to create a
report that will list all of the tests from both Dbs.  Db 1 - has a field

I have field names with data I'm trying to pull apart.  Ex:
1234 North Horse Hockey Ln 567
    North Horse Hockey Ln 678
1235       Horse Hockey Ln 987