Counting UK Post Code

  • Thread starter Thread starter How do you clear a report of data after
  • Start date Start date
H

How do you clear a report of data after

I would like to get total of post codes, my querys is layed as follows
Post Code - area(BB)- area(BL) how do i get total's in numeric value in
area(BB) etc
BB1 2QA
BL1 2ZZ
BB2 3XX
BL1 CC
 
Create a 2 column query. Set column 1 to
PCPrefix: Left([PostCode],2)
Set column 2 to
HowMany: Left([PostCode],2)
Click on the query totals button, leave column 1 as Group By and change
column 2 to Count
 
The below works but i would like to great a total in another column as a
numeric value i.e. Total 10

RonaldoOneNil said:
Create a 2 column query. Set column 1 to
PCPrefix: Left([PostCode],2)
Set column 2 to
HowMany: Left([PostCode],2)
Click on the query totals button, leave column 1 as Group By and change
column 2 to Count

How do you clear a report of data after said:
I would like to get total of post codes, my querys is layed as follows
Post Code - area(BB)- area(BL) how do i get total's in numeric value in
area(BB) etc
BB1 2QA
BL1 2ZZ
BB2 3XX
BL1 CC
Click to expand...
Click to expand...
 
Back
Top