|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 28th, 2007, 04:23 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Help with parameter query
I have a very simple query that has two parameters - [Enter Start
Date] and [Enter End Date]. The End Date should always be 90 days from the Start Date. I would like to just have the [Enter Start Date] parameter and have Access calculate the end date, but I have know knowledge of how to do this. Any ideas? TIA, Tim 
|
|
#2
February 28th, 2007, 04:39 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Help with parameter query
Change the criteria in the query to:
Between CDate([Enter Start Date]) And (CDate([Enter Start Date]) + 90) Zeunasc wrote: I have a very simple query that has two parameters - [Enter Start Date] and [Enter End Date]. The End Date should always be 90 days from the Start Date. I would like to just have the [Enter Start Date] parameter and have Access calculate the end date, but I have know knowledge of how to do this. Any ideas? TIA, Tim -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200702/1
|
|
#3
February 28th, 2007, 07:29 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Help with parameter query
Awesome... exactly what I needed!
Thanks! Tim
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
