criteria for Access paramater query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write selection criteria that will let me target mailings by
street names. The street name is part of the Address field. I want to be
able to enter up to three different street names at the time I'm ready to
print labels, and I just can't get the syntax correct. I can do it as a
select query, but not a parameter query. Can anyone help? Thanks!
 
I'm trying to write selection criteria that will let me target mailings by
street names. The street name is part of the Address field. I want to be
able to enter up to three different street names at the time I'm ready to
print labels, and I just can't get the syntax correct. I can do it as a
select query, but not a parameter query. Can anyone help? Thanks!
Click to expand...

This works for me.
WHERE ((InStr([Address],[enter A])>"0")) OR ((InStr([Address],[enter
B])>"0")) OR ((InStr([Address],[enter C])>"0"));

Enter up to 3 street names when prompted.
 
Back
Top