I wonder if anyone can help me with this simple question:
I have a table which includes a column with questionnaire numbers (which
contains duplicates) and another column with dates. I wish to write a query
which will return only questionnaire numbers with the latest (maximum) ...

I'm looking for help as to why the following UPDATE statement won't execute
in Access:
 UPDATE Orders
   SET CustomerName = c.CustomerName

I have read previous posts, but cannot come up with a solution that works.  I
have a database which tracks invoices per client.  Based on this, I am trying
to create a query which returns the "plan name" with latest date the client
was invoiced, or, if the client has never been ...

Good Day all,
I have a qry that I use to track my inventory, and for each inventory item
there is a field called colours. Which can contain anywhere from 1 to 15
colours separated by a comma.. I.E. (50, 123, 57, 98) are the colours for one

Re Access 97
I have a huge lookup table which I want to overwrite with newer data from
another table if the same records exist in both tables
If not, then add the record as a new record to the lookup table.

I want to check weather records avail in some table on some conditions
, right now i have to use the select count(*) in ms access,
performance point of view i can use if exists in ms sql, is there any
way we can do it in ms access also.

This should be easy.... but now, it is just getting frustrating
In a calculated field I want to use the expression "Max" to find largest
number of a series of numbers. In QBE, on the FIELD row I've written:
MaxOfMax:  Max(85;45;26;95;35;15;75)

I have  a table that has Queue Numbers with settings for each QueueNumber
Presently the data is stored like this:
QueueNum 1  Setting1  Setting2  Seting 3
QueueNum 2  Setting1  Setting2  Seting 3

I have tried to post this as a WHERE and or IIF statement question. It should
be not this difficult a query. I took my main table NameAddr this file
contains all of our customers with assigned customer numbers. Each branch has
a range of usage between 1 and 9999. Branch 01 only ...

I am building a very simple quote builder, and need direction on dealing with
the following...
I need to pass a parameter to an append query.  Not from a form, but from
Access VB.  The reason is that my Part Number, (my key for price lookups) is

Hallo there
I'm trying to run a select query which looks at data in another MS Access
2003 database using the 'Source Database' query property to specify the file
name and path.

I need to create a field in a query which counts the number of characters in
another field.
I have Len([Policy#])
The problem is this is a linked table from another database (advantage).  

I have an A2003 query that uses count(*) to return the number of reviews for
an employee.  Works great if you have at least 1 review; chokes when you
don't have any reviews.
How can I return the empty recordset?

Each month I export information from another database into Access.  There are
two tables involved:  One containts the old data, the other is the updated
data and contains all existing records including modifications to old records
and new data.  Each record has a unique field ID. ...

I have a query that works with one problem, the query searches tables
that have a relationship with the orps data table.  a couple of the
tables have many entries for each of the records in the orps data
table.  As a result, I get several repeats of data from the orps data