Changing record field values after make table query

[RandDUser]

I have tbl_Main that has 30,000 records. I have a make-table query (qry_MakeTBL) that extracts 500 random records from tbl_Main. What I want to happen is when qryMake_TBL runs, it changes the value of one of the fields in tbl_Main to a "1", that way I know which 500 random records the make-table query has pulled.

Here is some code of what I have tried:

qdf2.SQL = "UPDATE tbl_Main INNER JOIN [qry_MakeTBL] ON tbl_Main.Field1 = [tbl_MakeTBL].Field1 SET tbl_Main.Field1 = 1;

Any Suggestions?

Thank you

 

[PHV]

instead of qry_MakeTBL use the newly created table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886