I'm using zip codes to sort and compile information and I have a query where I run an inventory of people in a 3 digit zip code range like this
Left([qryLastMail]![zip],3) AS 3DigZip
The problem I'm having is in the zip codes where there is a leading zero like in MA 01001 the query returns 100 instead of the 010. How can I get it to count the leading zero. The field is already formatted with 5 digits and when I do the query to show all five it returns the numbers with the leading zero just fine.