I have something interesting...looking to see if anyone else has came across this.
I have a query with parameter [From Date] and [To Date] and the query works beautifully every time. However, when I use the wizard to build a report, at the end of the wizard the report opens beautifully, asks for the 2 parameters, and displays results. Beautiful. Then, after closing the report and re-opening, the report promts me for a third, unwanted parameter. [See the thread:
Using parameter queries in an Access REPORT--what is the extra parameter?.] (Don't get lost in all the technical stuff...at the end of the thread we discovered it's somethign different between Access 03 and Access 07. It seems was set up right to begin with (as far as we could tell.))An expert from Bytes tried to help me using Access 2003. He said he couldn't make the third parameter box come up. I tried it in 2003 and it indeed worked properly for me too. But in 2007, it still asks for this silly parameter. I have built the report at least 10 times and every time it does the exact same thing. I'm a beginner so go easy with the tech lingo. :-)
PS. My company is using 2007 optionally and saving files in 03 format so things are compatible with people who haven't upgraded.
If you pull up my DB from the linked thread, the report with the problem is rptHOTSTICK_FAILURE_BY_DATE. The first two parameters can handle "1/1/09" and "10/10/09." The query it comes from is HOTSTICK_FAILURE_BY_DATE Query.
Has anyone else had this problem and does anyone know a remedy?
Thanks in advance. Danica
