[AccessD] Sorting in a report

Tried it your way and no difference. I may just have to break it up into 3 groups.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Thursday, February 05, 2009 12:49 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sorting in a report

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.
>
 

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