Hi, i'm trying to set up a query that will do the following:

In table "OBJECTS" there is a field "REG_ID". The ID number is repetitive, and occurs in many spots in the field "REG_ID".
In table "CONTACTS", there is a field labeled "ID". The ID number is unique, and occurs only once in this table.
I would like the data associated with this number to be moved over to "REG_ID" anytime the 2 id's match up in a separate field in the "OBJECTS" table.
I made an "update query", and the total number of updates was around 3500. But none of the data was changed.
Anybody know what i'm doing wrong. I'm by no means an expert in access, but hoping someone can get me in the right direction.
Thanks!
Jason

Update queries do require that you 'run' them, not just view them. I know this threw me off at first. The button in the top left corner (View/Design/SQL) will show you the records that will be changed, though not what they will be changed to. There is a ! button about halfway across the toolbar in Design View that actually runs the query. You should get a confirmation message saying "3500 records are about to be updated. Are you sure?" or something to that effect.

HTH,
David R

Yes, i've been clicking on the "!" button, and getting the response to the effect that 3500 records are going to be updated. I still don't see any change in the data though.

It sounds like your criteria are correct (if you're expecting about 3500 records to be changed, that is), but your Update To: field isn't doing anything?
Without seeing your query I can't say what might be wrong. Can you post the SQL statement of it here? Perhaps someone can see what's fouled up..

David R

[This message has been edited by David R (edited 01-03-2002).]