First 3 numbers in Zip Code Query

[cshipley83]

Hi all. Tried looking for this problem, but couldn't find anything relating to it. I need to make a mailing label that will pull all zip codes starting with 344 from my main table. Not sure how to go about doing this. Any help would be great. Thanks.

[jwhite]

Look to use the Left() function on the field that contains the zip code. If still need help, please give us more information - table structure, sample records, etc.

[ranman256]

Select * from table where [zip] like "344*"

[orange]

How is zipcode Dimmed in your table?
If you have defined zipcode as Numeric, you may need to convert it to String using
CStr(zipcode) and then to get the first 3 "digits"

...Where Left(Cstr(zipcode),3) ="344"

[cshipley83]

Thanks for the help. I'm still so new at access and I don't work on it that often so I frequently forget stuff I've knew. Can you break it down a bit more for me. I'm not sure if I need to make a query first or go straight to making the label. Once one is made how do I get it to just pull up zip codes beginning with 344. My main table with the address information is called Donors. The Donors table has ACCTID, TITLE, FNAME, LNAME, ADDR1, CITY, STATE, ZIP fields. I need all these fields on the label, but only showing zip codes that begin with 344.

[cshipley83]

The ZIP field data type is short text in the design view of my table.

[orange]

Use ranman's suggestion

[cshipley83]

Thanks this worked. In ZIP Criteria I put: Like "344*"
Thanks for all the help