Parameter queries? Parameter nightmare!

[Rothron]

I have just discovered parameter queries and it appears they are just what I need. However, when opening the relevant report the dialog box asks for the paramater TWICE and then produces a report with no records in it.

I suspect it may be a problem with the way the query is set up. Any help would be appreciated. Thanks

 

[Abby N]

If you want the report to always ask for input when opented you can use a filter. In the reports property set the 'Filter On' option to Yes. For the 'Filter' enter:

NameOfDateField >= [Report from when?]

~Abby

 

[Abby N]

Don't take this personally. I'm just trying to help. Rather than deleting your original post and putting up the one above you would probably have been better off replying to, or editing, your original post with this new information. The reason being, anyone reading this topic now has a more difficult time understanding what you're trying to achieve and what you've tried already.

~Abby

[This message has been edited by Abby N (edited 09-25-2000).]

 

[Rothron]

Thanks for the advice. I am going to give the filter a go tomorrow (bad idea at the end of a horrible day!) and hopefully all will be well. Point taken about the message, though!

Thanks