Changing Groups at Runtime !

M

Mark

I currently have a report which is grouping on my field
"GROUP1" which gets changed by my sql at runtime.

The SQL my report is using is

Select [Client Data].State as GROUP1 ,
'State' as Gr1pName ,
*
FROM [Client Data]

However it still keeps asking me for a paramater value
for STATE in a message box
Any ideas how I can stop this from happening ???

Thanks in advance
 
Top