template for an UPDATE query that shows how to UPDATE multiple fields

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Carl23
    New Member
    • Mar 2012
    • 22
    #1

    template for an UPDATE query that shows how to UPDATE multiple fields

    Your template code works great for INSERT. Is there a template for an UPDATE query that shows how to UPDATE multiple fields INTO a table called TEMP from 2 other tables with a common field [TABLEA]report_num = [TABLEB]repo_num?
    Thanks,
    Carl
    Tags: None
    Previous template Next
    Working...