Update Query

[Mike Hughes]

I have two tables.
The first is called 2tbl and the second is called final
I want to write a query where
if 2tbl.date_end=12/31/9999 populate final.emp as "yes"
and 2tbl.mem = final.mem

Any ideas?

Thanks Mike

 

[Brianwarnock]

Join the tables on mem put your criteria in 2tbl.date_end and your update to "yes" in final.emp

Brian

 

[Mike Hughes]

Great,
Thanks Mike