lilmosweet
09-25-2009, 10:49 AM
I have a Date Parameter set up in my query for the user to input the start date but I need the result to return only 60 days after the input start date from the user. How do I achieve this in my access query?
Thanks!
boblarson
09-25-2009, 10:52 AM
I have a Date Parameter set up in my query for the user to input the start date but I need the result to return only 60 days after the input start date from the user. How do I achieve this in my access query?
Thanks!
The parameter should be:
>=[Enter Start Date] AND <=DateAdd("d",60,[Enter Start Date])
lilmosweet
09-25-2009, 11:15 AM
Thanks! You are the best! Have a great weekend!
boblarson
09-25-2009, 11:25 AM
Thanks! You are the best! Have a great weekend!
¡No problema! Have a great weekend yourself as well :)