access query 2007

3 posts / 0 new
Last post
djharrybb
access query 2007
i have a query what pops up with a text box saying please enter today's date and the date you enter anything before that its shows but i want it to show anything 30 days before the date entered how would i do that PLEASE HELP :)

   

hubby
Re: access query 2007

your question isnt very clear - but if i understand it right, instead of a blank box, you want the box to show a date that is 30 days before today?

djharrybb
Re: access query 2007
dont worry i have fixed it its =date()

Add new comment