Need help in MS Access Query

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
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query Date Parameter Issue 1
Access 2007 Update query not behaving 1
Delete Query with Joins problem 2
MS Access SQL conditional Append 6
Query with several tables. 5
select Statement w/i inner joins 4
SQL query to Access database 5
Join by field name? 2

Top