In access 2010, when performing a query based on date, how to have today's date show in the query box -

i have mail merge query in access 2010 asks date bases records merge date. when press query, prompts box put in date. of queries based on today's date find myself typing in today's date in query box often. query prompt show today's date , wait me either press ok or change date in prompt box select records based on query date.

if following shown in image, today's date if put yesterday's date in, both merged documents keyed off 2 dates. how can make work?

the problem here dialog getting missing parameter. it's nice trick able fill in parameter way, unfortunately can't interact dialog box in manner.

you're correct listing both date() function , [enter letter date] parameter both. because it's or clause.

one way solve problem build form captures date first. prefill textbox on form date() function.

with command button on form, launch mail merge or query.

your query changed refer value on form, instead of value entered in dialog, such =forms!mailmergeformyoucreate!letterdatetextbox