Original table
ocity    year    price
frankfort    2008    1200
frankfort    2009    500

I need help in creating a query that will find all unmatched records in a
table.
I have two tables:
The first table T1 has just has a record number

I wonder why the 'like" function does not work perperly. In my query i have
want use like to filter out the result. I used like "lightnin" on the
criteria to get the result for which column have this "lightnin" keyword, but
the result shows that it pull the "light, lighthouse, ...

I know it is not the best practice to use parameter query for user input(a
form is better) but I have inhereted this database and just want to make a
few minor changes.
I have a parameter query for Client ([client] that is a text field and it

This is giving me a syntax error
Update [table4] Set
Hyperlinkpart([table4],[hype],0)=Replace(Hyperlinkpart([table4],[hype],0),"tempest","trinity")

I am have to find out a %,    based on total(# of records)-
corrections/total(# of records)
The fields i have would be QCP_id, date, batch_id, and correction.
I would need to get the total amount of records by QCP_ID, using the count

I have a table called "Students - Enrolled" and I need to create an update
query that will put a "90%" in the [REFUND] column/field for the records that
have an "092" in the [TERM] column/field and the date in the [REG_AUDIT_DATE]
is between "5/12/09" and "5/13/09"

I have a table with 3 fields - Name, Lap1, Lap2.
I want to create a query that will shows the result with 2 fields. The 2
fields are Name and Best_Lap. The Best_Lap is the minimum between Lap1 and
Lap2. How can I do this?

I have a simple database to track each sales person's contacts and 6
different steps in the sales procress. Its not about contact management,
rather its all about the numbers...how many contacts, how many step taken,
total units sold. I need a query or report of some sort to give ...

What is wrong with this slq statemnt. When I hit my cmd button in my
form i get a pop up box that says "Enter Paramater Value"
GCriteria = Forms![frmSearchFields]![cboSearchField].value & " = " &
Forms![frmSearchFields]![txtSearchString].value

Access 2007
Table1:
Field: ABC (AutoNumber)
PrimaryKey: ABC

I have a database which details holidays, and I have had to construct it
specifically to include all dates.  I want to make a field that specifies
whether the holiday is future or past - I cannot work out how to speficy that
if the date is larger than today the field should read ...

I have a table of staff effort data, containing the following fields:
FY
WBS
Period

About four years ago, I created a query that pulled records based on the
items selected. Sex, race, hair color, eye color were all combo boxes and the
user selected those that matched.  They also selected whether the person wore
glasses was bald, had a mustache, beard, etc.  ...

I have a table (tblRecords) with specific times (long time) for each record.
From a query I need to group the resulting records by hour military time
(0600, 0700, 0800....)
I've created another table named tblTime with 3 colums