Group on part of field

[Keith]

I have a linked table containing a field 'FacilityType' which I can't alter.

Entries are:
Senior Football Pitch Grade 1
Senior Football Pitch Grade 2
Junior Football Pitch Grade 1
Junior Football Pitch Grade 2
Netball Indoor
Netball Outdoor
Cricket Outdoor
Cricket Indoor
Rugby Pitch Grade 1
Rugby Pitch Grade 2
Athletics Track

I need to produce a report grouped on the words Football, Netball, Cricket, Rugby and Athletics. Can someone please point me in the right direction for a solution.

Seasons greetings and kind regards, Keith

 

[ColinEssex]

Have another field in the table to identify the generic name. For example call it "Sport" and then use an update query and an Instr() function so any of the Facility Type entries that contain Football - enter Football in the Sport field.

Then group on that.

Col

 

[Keith]

Thanks Colin, I have taken your advice and added the extra field to group on.