• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 742
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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