Updating table from a temp table

[ktariske]

Hi,

I use a temp table to gather information from a bar code scanner, simply a machine ID number from 1-999. I want to update another table, then clear the temp table to start another 'batch'.

I need to compare if the item is a valid id in this table, then update a yes/no field within that record. What kind of code do I need? A macro? An expression? A query?

Clueless,

Kriss Tariske
Redlands, CA

 

[bradcccs]

Use an update query.

The design grid should include your "Temp Table" and your "Other Table"

Create an inner join between the relevant fields (ID numbers?)

This will display only records common to both tables.

Set your Yes/No field in the "other table" to update to True (or false?)

Brad

 

[ktariske]

Thanks

I'll give it a go, thanks.