Macros

[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,

 

[Guest]

Hi
Just try to use the expression, "=Now()", where ever you want to insert
current date. I hope this will work.
Mahesh

 

[Douglas J. Steele]

Use = Date wherever you want to insert the current date. = Now inserts the
current date AND time.

 

[mbynoe via AccessMonster.com]

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

[quoted text clipped - 15 lines]