Group Header

[SusanHRO]

I'm a beginner at Access, so bear with me here.

I have many different categories under my "Facility Type" field and have separated them into separate groups. It's something like this (but many more):

Commercial - Banks
Commercial - Offices

Educational - High
Educational - Elementary

Residence - Multi

I want to display "Commercial" "Educational" and "Residence" respectively as my text that shows up under the Group Header. Access gives me the option of whole field, 1 letter, 2 letter, 3 letter, etc.
Whole field won't work because I don't want to see the " - Banks". By letter number doesn't work, because the different words have different numbers of letters in them.
What I want to know is if there is an option to show the just the first word.
If not, any suggestions?
Thanks!

[pbaldy]

If they consistently follow that pattern, you could add a field to the query using the Left() and InStr() functions, and use that. InStr() to find the position of the first space (or the hyphen).

[SusanHRO]

If they consistently follow that pattern, you could add a field to the query using the Left() and InStr() functions, and use that. InStr() to find the position of the first space (or the hyphen).

Okay, I think I understand how I would use those two functions - I'd basically be creating a new field with just the first words, correct?
However, once I do that, how would I turn that field into my headings? I don't want to change the actually groups - I need to keep those as they are.
Also - super n00b question - once I add a field in my query how can I add that field to my existing report without starting over?

[pbaldy]

Once you add a field to the query it will be available to be used on the report. You can change the control source of an existing textbox to it or add a new textbox. If adding that field to the query changes the result in some way, another alternative is to leave the existing field in Sorting and Grouping, but to use those functions in the textbox instead of the actual field name (=Left(...))

[SusanHRO]

I got it to work! Thank you so much for the kind and timely assistance!

[pbaldy]

Happy to help, and welcome to the site by the way!