Update Criteria field on Query

[rgreene]

Hello All,
I am using Access 2010 and I'm trying to automate a report that we run every morning. What I want to do is click a button and have it open my query (query1) in design mode then go the Date field and change the Criteria to todays date. Is this possible? The other part of this is to email the report that this query uses. I have the email portion done but I can't figure out how to change the criteria on the query.

Thanks in advance,

Rick

 

[plog]

Why don't you change the criteria of the query to this:

Date()

That automatically retrieves today's date--you'd never manually have to touch that query again.

>>The other part of this is to email the report that this query uses<<

Queries typically don't use reports--its vice versa.

 

[rgreene]

Plog
"Queries typically don't use reports--its vice versa" my bad I had it reversed.

Thanks for the date(), I guess I was trying to make this a lot harder than it needed to be.