[AccessD] Sorting in a report

Steve Schapel miscellany at mvps.org
Thu Feb 5 12:49:12 CST 2009


Chester,

For an expression to work in the Sorting & Grouping, you need to put the = 
in front, e.g.
=[DayCount1000] & [WellName]

Also, if one of the fields is a number, I think the result of the overall 
expression will be a string, so you might need to do something like:
=Format([DayCount1000],"0000") & [WellName]

Regards
Steve


--------------------------------------------------
From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
Sent: Friday, February 06, 2009 3:28 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Sorting in a report

> Here are the grouping and sorting criteria I used
> [DayCount1000] & [WellName] Descending
> [DayCount500] & [WellName] Descending
> [DayCount200] & [WellName] Descending
> The WellNames that had a value for DayCount1000 appeared at the top of the 
> report sorted by WellName. The remainder of the data appeared below sorted 
> by WellName. No sorting occurred on DayCount500 or DayCount200.
>
 




More information about the AccessD mailing list