Hi All,
I'm having difficulty counting the number of "Y" and "N" for each suburb.
Details:
The Table -
--------------------------------------------------------
ID- Shop Type-Shop Name-Address1 - Address2 - Suburb - State
--------------------------------------------------------
1 - LP- ExampleName - 1/2 Example St - West Example
The result I need is:
--------------------------------------------------------
Suburb - State - Count No. of "Y" - Count No. of "N"
--------------------------------------------------------
West Example - TT - 4 - 5
East Example - WW - 1 - 0
There are also duplicate suburbs.
Any direction or help is much appreciated
Thank You,
Dave
I'm having difficulty counting the number of "Y" and "N" for each suburb.
Details:
The Table -
--------------------------------------------------------
ID- Shop Type-Shop Name-Address1 - Address2 - Suburb - State
--------------------------------------------------------
1 - LP- ExampleName - 1/2 Example St - West Example
The result I need is:
--------------------------------------------------------
Suburb - State - Count No. of "Y" - Count No. of "N"
--------------------------------------------------------
West Example - TT - 4 - 5
East Example - WW - 1 - 0
There are also duplicate suburbs.
Any direction or help is much appreciated
Thank You,
Dave