Can someone makes this update query in Microsoft Access and tell me how it would be if I type it on the SQL view plz? The tables for the query are Transactions and Balance (I suggest to enforce referencial integrity before making the query plz). The fields for the Transactions table are:

- TransactionID (primary key)
- AccountID (foreign key/number)
- Amount (number)
- Type (short text)
- Purpose (short text)
- TransactionDate (Date/time)
- Settle (yes/no)

Fields of the Balance table:
- BalanceID (Primary key)
- AccountID (foreign key/number)
- Amount (number)
- CreationDate (Date/time)

Instructions: Update Query for Changing the Settle Status to Yes after you have applied the proper Decrease or Increase amount on the balance table belonging to a specific Transaction and AccountID. Ensure Criteria.

Btw for the AccountID it’s from another table that is not used in the creation of this query but I’ll leave down here anyways.

- AccountID (primary key)
- CreationDate (date/time)
- Type (short text)