Update Query Finds Different Number of Records Than Select Query

[mjbigelow]

Hello All,

I have a SELECT query that queries a single table, based on four
criteria, and returns 96 records. If I change the query type to UPDATE
and put in the value to which the records are to be updated, it tells
me it's about to update 0 records. I don't change any of the criteria
at all. I'm a little stumped, so your help will be greatly
appreciated.

Thanks!
Mark

 

[Judy]

Hey,

From my knowledge of queries, what you really need to do is put an actual
date for the criteria, as in current date (up-to-date), 07/21/2005.

 

[Chaim]

Mark,

Could you send us the SELECT statement and the UPDATE statement? I assume
you are creating them in the Query Builder. To get the SQL, open your SELECT
query in the Query Designer, right click on the table area, and select 'SQL
View', copy the statement. Then go back to 'Design View' (right click again),
change the Query Type, modify the grid accordingly, go back to 'SQL View' and
get that statement.

Then post it for us.

Also, are there no other messages in the popup that is displayed? Just the
message that '0 records will be updated'?