Can you update a table value based on query?

[systemx]

Hi all,

Simple question...I think. Is it possible to update values in a table, based on the results of a query?

For example, I have tblPRR and qryProcessed.

When I run qryProcessed, I would like the field "Status" in 'tblPRR' to update from 'No' to 'Yes'.

Could anyone advise if this is possible?

Cheers

Rob

 

[MStef]

Do it with UPDATE query.

 

[systemx]

Thanks MStef...just dropped back in to say I found out how to do it.....

I did search the forums and google prior to posting...but as usual my search terms let me down

Thanks

Rob