Need help in MS Access Query

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

I have a query in MS Access

Select TableA.Field1, TableA.Field2,TableB.Field3,TableC.Field4
From TableA,TableB,TableC
Click to expand...

Now is it possible that after this query runs from any where, the value
in TableA.Field2 changes to lets say "2"
I want to rephrase my problem, I have a query that runs from vba codes,
but after this query runs, I want to update TableA.Field2 to "2" in
TableA.

Let me know if its possible in one query.
Thanks
 
I want to update TableA.Field2 to "2" in TableA.

Why are you selecting the other tables and fields if you want to update this
one field?
 
Back
Top