I am trying to create an update query with SQL inside a VBA module. I don't know how to 1. relate fields in two different tables. 2. update a field in one of the tables if the relationship above holds.
Could you please send me an example?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.