Sort by Last Name, Group by ID Number? 2

[thirtydash9]

Hi,

I have a report based on a query with sortNum as the unique ID number and last (last name), among other fields.

For each sortNum there can be one or more query results.
So, on the report it makes sense to have a sortNum header with the labels and the text boxes in the detail section, right?

But, sortNum is invisible on the report. I want the report to be sorted by last name (the underlying query is sorted by last name).

If I create a last name header, then people with the same last name end up together in the report.

What to do???

Thanks

 

[dhookom]

If you sort by last name then it makes sense that people with the same last name end up together. Are you experiencing issues with group headers and/or footers? If so, you can sort by:
=[Last Name] & [sortNum]
Display your headers and footers on this grouping expression.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[AlexMidd]

You can sort by lastname and sortnum but only put a header for sortnum, thus effectively only showing the grouping for sortnum.

Have fun! )

Alex Middleton

 

[thirtydash9]

Hooray! Tek-Tips to the rescue yet again.

I didn't realize that you could use the grouping/sorting window to sort without grouping.

I took your advice and first sorted by lastname in the grouping/sorting window without any header or footer, and on the second line put sortnum with a group header, thereby ensuring that people with the same last name don't get mistaken for one person.

You guys rock as always.