Macros

  • Thread starter Thread starter mbynoe via AccessMonster.com
  • Start date Start date
M

mbynoe via AccessMonster.com

I have created a macro that runs several queires...now, I want to set a
condition where the user don't have to to input the date....I want them to be
able to click a button and it will give them the current date information
based off of the MAX date information in the table.

...Start Date: Select DateAdd("d", 1, Max(prod_date_time)) AS StartDate
FROM workingnew;

...End Date: SELECT date();

Am I going in the right directions

Thanks,
 
Hi
Just try to use the expression, "=Now()", where ever you want to insert
current date. I hope this will work.
Mahesh
 
Use = Date wherever you want to insert the current date. = Now inserts the
current date AND time.
 
Thanks!

MB
Use = Date wherever you want to insert the current date. = Now inserts the
current date AND time.
Hi
Just try to use the expression, "=Now()", where ever you want to insert
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
Back
Top