Add section header in form while creating in design view?

[Sue]

I can't figure out how to do it. I want to be able to use sorting/grouping
from a field currently in the detail section; if I add a section header that
relates to that detail section, I can have that be my "main sort field",
n'est-ce pas?

 

[fredg]

I can't figure out how to do it. I want to be able to use sorting/grouping
from a field currently in the detail section; if I add a section header that
relates to that detail section, I can have that be my "main sort field",
n'est-ce pas?

Perhaps you are thinking of a Report's Group Header.
You are wanting to do this in a FORM, correct?
Form's do not have Group Headers.
Forms are sorted by the form's recordsource.

Create a query with all of the fields, and then sort the query on the
field wanted. Make that query the form's record source.

 

[Sue]

Hi Fred,
Thanks for your reply, but I don't think I'm expressing myself well.
Say I've used design view to create a form dealing with all the "big cats"
in zoos.
I have 5 zoos spread across the nation.
I have lions & tigers & pumas.
How do I have the report display so that all the big cats in San Francisco
are listed first, then all the big cats in Washington, with cats sorted by
lions & tigers & pumas at each zoo?
At this point, my report won't do that.
Again, thanks.