|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 2nd, 2009, 12:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Select a query showing only selective post codes relating a relevant postal area
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200912/1 
|
|
#2
December 2nd, 2009, 01:38 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Select a query showing only selective post codes relating a relevantpostal area
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 chedd via AccessMonster.com wrote: 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
|
|
#3
December 2nd, 2009, 01:38 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Select a query showing only selective post codes relating a relevantpostal area
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 chedd via AccessMonster.com wrote: 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
|
|
#4
December 2nd, 2009, 01:38 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Select a query showing only selective post codes relating a relevantpostal area
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 chedd via AccessMonster.com wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
