Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

Access Update Query Wizard: Criteria with "and" instead of "or"

When I am working with the Update Query Wizard, I noticed it only provides for a Criteria and the next line is "or".  How do I change this "or" to and "and"?
Below is an example of how I would use this.  Thank you.
I am mainly interested in using the Access Query Wizard.  I am not that proficient with Access.  Thank you.  

Field:               Base Rate              
Table:              Trans              
Update to:       .11                      
Criteria:           [Trans]![Cty]="USA"
and:                 [Trans]![Sls]=2
0
ThomasJue
Asked:
ThomasJue
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
what is [Trn] ?
0
 
ThomasJueAuthor Commented:
It was a typo. I meant the Trans table, so it should read:

Criteria:           [Trans]![Cty]="USA"
and:                 [Trans]![Sls]=2
0
 
Rey Obrero (Capricorn1)Commented:
xto create an "And" criteria
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now