[AccessD] Report - Grouping and Sorting - Cross posted

Boehm, Gary D. gdb at AllenandAllen.com
Tue May 11 12:05:33 CDT 2004


Hello all, from the perpetual newbie. I've run a query on the fields
listed below (among others) from several tables in a database, in order
to list open items from a checklist (description).

LastName
FirstName
CaseNumber
Description
CloseDate

The goal is to list open checklist items and sort by name. The problem
is that there are unique case numbers but identical names across the
unique case numbers. I need to group and sort by name but when I do
that, it combines identical names under one case number. How can I tell
Access to group by case number but sort by name?

Access 2002 SP-2

Gary Boehm



More information about the AccessD mailing list