[AccessD] Report Grouping on a derived query field

Andy, thanks, tried that and same result.

Stephen 

> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> Sent: Friday, 23 July 2004 11:03 p.m.
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Report Grouping on a derived query field
> 
> 
> Stephen
> How about trying this. Create a public function to which you 
> pass StartDate
> and which returns the correct Year. Then replace your IIF 
> test in the query
> with the function call and group on that. Might make the SQL 
> 'simpler' so
> Access can cope. Haven't tried it but may work.
> 
>
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>