I want to pull all addresses with zips starting with 970. How do I enter that in the query?
S Sue Bronson May 8, 2012 #1 I want to pull all addresses with zips starting with 970. How do I enter that in the query?
J John W. Vinson May 8, 2012 #2 I want to pull all addresses with zips starting with 970. How do I enter that in the query? Click to expand... That depends on the datatype of the Zip field. It *should* be a text field - if so you would use a criterion LIKE "970*" If it's Number, change it; or if you can't for some reason and it's a Number like 97024, put in a calculated field [Zip] \ 100 and use a critieron of 970. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com
I want to pull all addresses with zips starting with 970. How do I enter that in the query? Click to expand... That depends on the datatype of the Zip field. It *should* be a text field - if so you would use a criterion LIKE "970*" If it's Number, change it; or if you can't for some reason and it's a Number like 97024, put in a calculated field [Zip] \ 100 and use a critieron of 970. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com
