Sort Postcodes

[tedc]

I have a list of club members with their address and post (zip) codes.
I would like to be able to extract data that lies between 2250 and 2420 zip codes inclusive.
Thanks in advance

 

[Trevor G]

You would need to look at creating a query to fulfill this if you want to keep a list.

Create New Query Design View > Select Table and then Fields > In Zip Code Criteria (Below tick box) add in this Between "2250" And "2420"

Sample SQL statement shows this, I have used the Northwind Traders sample database

SELECT Customers.CompanyName, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers
WHERE (((Customers.PostalCode) Between "2250" And "2420") AND ((Customers.Country)="usa"));

 

[tedc]

Thanks Trevor... works great, your bloods worth bottling
cheers
Ted

 

[dogdays]

If those are actually US zipcodes you should have the field defined as text, that way you will not lose the leading zero. If not US just ignore this message.

Jack

 

[Trevor G]

Thanks Trevor... works great, your bloods worth bottling
cheers
Ted

Pleased to read you have a solution Ted, happy to help.