[AccessD] Report - Grouping and Sorting - Cross posted

Gary, here's how to combine two fields into one.  Watch for line wrap.

FullName: [tblName]![LastName] & ", " & [tblName]![FirstName]



Mark


-----Original Message-----
From: Boehm, Gary D. [mailto:gdb at allenandallen.com] 
Sent: Wednesday, May 12, 2004 8:54 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Report - Grouping and Sorting - Cross posted


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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com