By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,052 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,052 IT Pros & Developers. It's quick & easy.

Reports, select criteria and run-time prompts

P: 13
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
Jan 15 '09 #1
Share this Question
Share on Google+
5 Replies


P: 13
Sorry, meant to say it's Access 2007.
Jan 15 '09 #2

Delerna
Expert 100+
P: 1,134
Everything is possible in one way or another. More detail please?
Jan 16 '09 #3

P: 13
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
Jan 16 '09 #4

Delerna
Expert 100+
P: 1,134
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?
Jan 17 '09 #5

P: 13
Thanks Delerna, that sounds great...I will give it a go later.
Emma
Jan 17 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.