Still having problems with postcode query

[shopoholic]

Am trying to query a customer database to find a how many instances of each postcode exist to determine geographic distribution. Only interested in the first part of the postcode so the following code was suggested:

SELECT Count(owners.Field8) AS Total, Left$([Field8], Len([Field8])-3) AS Code
FROM owners;

However it returned a message saying "you tried to execute a query that does not include the specified expression 'Left$([Field8], Len([Field8])-3)' as part of an aggregate funtion.

What does this mean?

 

[Smart]

Re: post code query

Try a query with the following code

SELECT Count(Table2.code) AS CountOfcode, Table2.code, Left(

,3) AS 1st3, Right([code],3) AS last3
FROM Table2
GROUP BY Table2.code, Left([code],3), Right([code],3);