[AccessD] Report - Grouping and Sorting - Cross posted

Boehm, Gary D. gdb at AllenandAllen.com
Wed May 12 07:54:12 CDT 2004


Thank you Roz, that did the trick. Unfortunately, I don't know how to
put the last and first names into one field so I had to group three
ways, by last name, by first name and by case number but the report now
does what we need it to do.  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Roz Clarke
Sent: Wednesday, May 12, 2004 4:01 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Report - Grouping and Sorting - Cross posted

Hi Gary

You need to group your report by both name and case number. Have a
grouping level of name but with no sections (header or footer). Attach
your sections to the case number grouping level - all your details will
appear per case number.

HTH

Roz

-----Original Message-----
From: Boehm, Gary D. [mailto:gdb at AllenandAllen.com]
Sent: 11 May 2004 18:06
To: Access Developers discussion and problem solving
Subject: [AccessD] Report - Grouping and Sorting - Cross posted


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