[AccessD] Report Ordering

Reuben
If I've understood right, what you need to do is define both groups but then
base them on calculated fields in your Query. The calculated fields would
return identical values for the unselected criterion. Something like:

SELECT Iif(frm!txtSort="Alpha",0,[fldNumeric]) As NumericKey,
Iif(frm!txtSort="Alpha",[fldAlpha],"") As AlphaKey

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Reuben Cummings
> Sent: 13 January 2005 19:09
> To: AccessD
> Subject: [AccessD] Report Ordering
> 
> 
> I have a report that currently has 4 entries in Sorting and Grouping.
> 
> I now have a couple clients that need this report to be 
> alphabetical before numerical.  Currently alphabetical is not 
> even an option.  Alpha would need to be the 2nd entry and the 
> other 3 should move down to 3rd, 4th, and 5th.
> 
> How do I work with and edit the sorting and grouping based on 
> user criteria. I figured I would place a check box on the 
> print form so the user could select numberical or alpha.
> 
> Thanks.
> 
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>