[MS_AccessPros] Grouping on multiple criteria question

 

Hello all,

I have 20 geographical codes for an area that I would like to create a query that will group multiple geographical areas into 5 areas. I tried to create a query that had the following

Geo Code 1: [Geo Code]=Like "AB6 A" Or "AB6 B" Or "AB6 C" Or " CD6 A"
Geo Code 2: [Geo Code]Like "CD7 A" Or "CD7 C"
Geo Code 3: [Geo Code]Like " CD6 B" Or "CD6 C" Or "CD6 D"
Geo Code 4: [Geo Code]
Geo Code 5: [Geo Code]

But it returns no records after the first geo code 1.

Is there a way of grouping these codes into bigger areas?

Thank You

Jim Wagner

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Links 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___