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