Reports, select criteria and run-time prompts

[emrodge]

Hi,
I'm trying to design some reports which pick up action points at certain dates.
Is it possible for select criteria to be based on a run time prompt - i.e. a date field being > than or = to a date entered at run time?
Many thanks for any help,
Emma

[emrodge]

Sorry, meant to say it's Access 2007.

[Delerna]

Everything is possible in one way or another. More detail please?

[emrodge]

Hi,
Thanks for your response. I have a table called Actions in a database and the table holds a date action created field and a date action to be completed field. I'd like to set up a report which selects any actions where the date to be completed is greater than or equal to a date specified at run time.
Many thanks,
Emma

[Delerna]

Hi Emma
I have a few ideas in mind but am unsure which way to help you!

I will take the simplest and assume that the term "report" means query.
If you create a query on your actions table you can open the query in design view. In the criteria property for the date to be completed field enter

>=[Please Enter The Minimum Date]

Note: the "please enter the minimum date" string can actually be anything you like but it must be enclosed in square brackets and it must not be the same as a field name.

For my example, what will happen is this.
You run the query
It will discover that there is no field called
[Please Enter The Minimum Date]
so a message box will pop up asking you to enter a value for it.
You enter the date
The query return all records where
Completed Date >= the date you entered.

I use access 2003 but I am pretty sure this will work in 2007 :)

Does that help?

[emrodge]

Thanks Delerna, that sounds great...I will give it a go later.
Emma