[AccessD] Sorting in a report

Chester,

In the Sorting & Grouping dialog, you can enter an expression in the 
'Field/Expression' box, for example:
=[OneField] & [AnotherField]

Does that help?

Regards
Steve


--------------------------------------------------
From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
Sent: Thursday, February 05, 2009 10:43 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Sorting in a report

> I have a report with 4 columns. The user wants the data sorted by the 
> second column and then by the first column then sorted by the third column 
> and the first column and then by the third column and the first column. I 
> can get ti to sort by the second then third then fourth column but I 
> cannot see how do do a subsort of the first column for ech of the other 
> three column sorts. Hope this makes sense. Or do I need to use three sub 
> reports? Thanks.
>