SQL Grouping problem!

Hi

I am working on a simple database for a local skatepark, and there are two reports I am struggling with. The first is a report which details the parks members, it currently counts all the members and groups them by postcode the problem with this is that the entire postcode (eg EX12 5RT) is to specific they would prefer the groups to be based in the first three or four digits (eg EX2 or EX12) of the postcode any ideas on how to do this would be grately recieved.

The second problem is that they would like a list of the top 10 members with the most visits, the amount of visits for each member is held in a table it is purely the problem of getting the top 10??

The reports are currently based on 2 queries and their running on Access 2002

Any help for a newbie would be very much appreciated

Cheers
Simon

USe the LEFT function to trim the postal code down to 3 or 4

S-