Competent Performer
Windows 7 64bit 
Access 2010 64bit
My company wants me to run a high level report which ask for three filters. However as its high level they want it should run with a click instead of choosing filters from three drop down
As this report comes out as a graph I can't use report wizard to run tabular report. Can you suggest me any smart way that they click a button and get filtered data in graph form.
VIP
Windows Vista Access 2010 32bit
If the filters are permanent (hence no combos) then put them in the query.
The report will feed off that.
Competent Performer
Windows 7 64bit Access 2010 64bit
No filters are not permanent
VIP
Windows 7 64bit Access 2010 32bit
What do you mean? The filter criteria is static or it is dynamic. Which is it?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows Vista Access 2010 32bit
If not perm, then SOMEONE MUST click a control to filter something. No telepathy here.
Competent Performer
Windows 7 64bit Access 2010 64bit
Filters are not static They change every time
VIP
Windows 7 64bit Access 2010 32bit
What changes them if the users do not select from comboboxes?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Report does NOT open on BUTTON CLICK
Posting Permissions
Reply With Quote