We are trying to generate a query which will be used as the basis for an
upcoming report.  The query needs to select records from within a date range
but the date range is dependent upon another field (TruckID).  The report
will compile information grouped by TruckID.  The date ...

Trying to run:
UPDATE tblActivityQuestions AS A SET A.QuestionID = (SELECT Q.ID FROM
tblQuestions As Q WHERE A.ChecklistID = Q.ChecklistID AND A.Sequence =
Q.Sequence);

In the source table for the query below, Ccy is a numeric field and there are
a number of blank fields.  I want the query to return only records where Ccy
is empty(I have tried "Isempty" "IsNull" "IsMissing" and the the result is
always the same, no records.  Ther query I have ...

I am working with a field that contains a Description and 3 character code.
Normally the field contains  a space between the description and the code.
Sometimes there are variations, but they are limited to the following
xxxxxxxx xxx (normal)

I have a table called Course need to be updated. It is like this:
Sect         Type
0352
0352

Trying to understand why I get "no unique index" message in my database
when I try to create a cascading relationship between two of my tables.
Here are the tables involved:
3 Tables joined to each other in the following manners:

Hello, I need to query a table to find unique values such that given the
below table,
name     claimant   loss date   close date   report date   name2    amt paid
vermal    ashford      010105    020506         020505     vermal     $10000

I have three tables that are similarly structured.  I need to pull data
from all three tables, and create a report that details those record
that meet selected criteria.
I know that I could create one make table query and two append queries,

I'm doing a cross-tab query and using one Where clause that looks up a value
in a combo box. No matter how I build the criteria, I always get message:
"MS JET DB does not recognize '[Forms]![frm1]![cboName] as a valid field.
Oddly enough, it works fine on my other form. Any ideas?

I would like to create an expression for citeria in a query.  The field is a
text field and I would like to query those records which have >4 characters.  
How would I write the expression?

Can I send an Excel spreadsheet that shows what I'm attempting to accomplish?
I need some help with a query.  I'm not sure what kind of query to use, and
if it's a crosstab, how to force it to allow 6 or more column headings and
sums of values in each column.

I'm trying to build a sales report of sorts.  
First I have a client table which contains Account numbers.
Now I have a second table with all of the sales info.  This includes
shipper, consignee, payor, date, and revenue.

I have 3 tables, Tbl_A is many-to-many with Tbl_B. The pertinent columns are
as follows:
Tbl_A : DoctorID, DoctorName
Tbl_AB_Relate: ContactID, BoardID (foreign keys for Tbl_A and Tbl_B)

I have to have a criteria in a field where the data must not match the first
3 letters in the Location name unless the accounting unit is 19.
I have entered this expression in the criteria  and I recieve an error.
Is this a syntax problem? What would be correct

Database and data is stored on a server. One workstation shows a different
result to a date calculation.  What setting on the workstation needs to be
changed?