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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Changing Groups at Runtime ! 2
group on first line instead of offset 3
Report Grouping & Subtotals 1
Query Help 1
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Summary sheet in effecient way 0
Data provider could not be initialized 1

Top