Changing Groups at Runtime !

  • Thread starter Thread starter Mark
  • Start date Start date
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]
Where [Client Data].Borrower <> 'XXXXXXXXXX'
And State = 'NSW'

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


Thanks in advance
 
Try

Select [Client Data].State as GROUP1 ,
'State' as Gr1pName , *
FROM [Client Data]
Where [Client Data].Borrower <> 'XXXXXXXXXX'
And [Client Data].State = 'NSW'

If it still asks you for STATE, it is likely to be something in your Report.
 
Back
Top