I have a form that contains over 3,000 records. The majority of records have the field "Will Expire" set to 04/16/2002. I need to change only those records that say 04/16/2002 to 04/30/2002 using an update query. How do I do that?

Thanks!

Change Query type to Update Query.
Include the date field.
In the Update To: 4/30/2002
In the Criteria: 4/16/2002 (it will add the #s)

Run the query (red exclamation point) on toolbar.

Curse when it does something you don't intend. Go back to your backup copy (you did make a backup, right?) and add additional fields to narrow down to just the records you really want. You can 'view' other fields in your update query by including them without any Update To: value, and clicking the usual 'Query View' button instead of Run immediately.

Good luck,
David R