update query

[sueviolet]

I understand that I need to create a update query, I just dont know how. It seems that I need to have 2 "where" criterias (but then again what do I know)I get confused at the "update to" part of the query grid.


The blank or 0 records of table main, field meta_data_id need to be updated by records 13-2151 of table metadata, field metadata_id.

Can someone please show me how (and if) i can do this?

Thanks so much

 

[pitou]

Hello Sueviolet

Well, in fact concerning to Jon K, you do not have to create an update query but to use VBA. Just re-read the previous message he wrote.

jean-Pierre