D
Dennis
I'm opening up a form that lets a user select what criteria he wants to
filter a report by. Things like tech Name, Start and End Date range, Company
Name, etc. All fine. Done it all before.I pass that information into the
query that underlies the report. No sweat. HOWEVER (heh), I want the user to
be able to choose how he wants to sort the report (minor sort, not the major)
via a radio button/frame. Never having done THAT before, I realize that I
need to be able to add a sort/group to the report programmatically. (Note
that this will not be a permanent change to the report, so I don't want to
save the change when the report is closed.)
I will also need to create a Group Footer and add SUM controls to it, and
place them at the appropriate x-y coordinates. I have not done ANY of that,
ever, in 5+ years of working with Access. Can someone please point me in the
right direction on all this? I'd sure appreciate it!
Access 2003 in this case.
TIA!
filter a report by. Things like tech Name, Start and End Date range, Company
Name, etc. All fine. Done it all before.I pass that information into the
query that underlies the report. No sweat. HOWEVER (heh), I want the user to
be able to choose how he wants to sort the report (minor sort, not the major)
via a radio button/frame. Never having done THAT before, I realize that I
need to be able to add a sort/group to the report programmatically. (Note
that this will not be a permanent change to the report, so I don't want to
save the change when the report is closed.)
I will also need to create a Group Footer and add SUM controls to it, and
place them at the appropriate x-y coordinates. I have not done ANY of that,
ever, in 5+ years of working with Access. Can someone please point me in the
right direction on all this? I'd sure appreciate it!
Access 2003 in this case.
TIA!