Select a query showing only selective post codes relating a relevant postal area

[chedd via AccessMonster.com]

Hi

please could you help as i would like to run a query only selecting relevant
post codes from my database. The post codes i would like to select are from
ST1 to ST4, ST6 to ST7.

Thank you spending time to help this issue

Chedd

 

[John Spencer]

I assume that those are the starting three characters of the post code and
that the next character is a space. You could try a query using the criteria

Between "ST1" and "ST4 zzzzzz" OR Between "ST6" and "ST7 zzzzzzz"

But I think for this specific example I would use the following criteria
LIKE "ST[123467]*"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County