Table to Unique Table with count

  • Thread starter Thread starter Nick Read
  • Start date Start date
N

Nick Read

Is it possible to create a query that can be used on a
table similar to the one below to produce a table that
would display the one record for each of the different
area names and how many times it occurred in the parent
table.

Thanks

Nick

The table:-

Gender Race Disability area name

F W1 N Staffordshire
F W1 N Staffordshire
F W1 N Surrey
F W1 N Surrey
 
Sure, a Crosstab Query is perfect 4 this. Make Area Name,
Disability, Race and Gender your Row Headings. Then Area
Name to the query again as a Value field counting it.
 
Back
Top