I have created a report based on a query. In the query I have a parameter set up. It runs fine, but when I try to run the report it will ask that particular parameter twice. How do I get rid of this? TIA
I have created a report based on a query. In the query I have a parameter set up. It runs fine, but when I try to run the report it will ask that particular parameter twice. How do I get rid of this? TIA
Just went through a similar issue with another poster. Involved an aggregate GROUP BY query that was based on a normal SELECT query with parameters. Remove the parameters from the SELECT and the aggregate query had no popups.
I never use dynamic parameters in queries. I use VBA to pass filter criteria to form or report.
Especially don't like popup inputs because can't validate entry.
Create a form for input of criteria. Reference the form controls as inputs. No popup prompts and the query should run.
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.