Counting UK Post Code

[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

 

[RonaldoOneNil]

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]

The below works but i would like to great a total in another column as a
numeric value i.e. Total 10

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

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