P
Pennington
? have a table of names and addresses including a 7 digit postcode E.g BA16
7TY in a list of other BA* together with TA*, GL* etc. When I create a query
with Like "BA*" in the criteria it counts individual postcodes and as few
people have exactly the same postcode I get a list of "1s" and it does not
sum them for the group. How do I write a query that counts the number of
people with the same two digits of the postcode?
7TY in a list of other BA* together with TA*, GL* etc. When I create a query
with Like "BA*" in the criteria it counts individual postcodes and as few
people have exactly the same postcode I get a list of "1s" and it does not
sum them for the group. How do I write a query that counts the number of
people with the same two digits of the postcode?