Populating Date

[avagodro]

I have a database for postage logs at my job. I have over 60 areas that I have to enter postage on a daily basis for.
Rather than having to enter the date for each area, every day, I would like to run a query that will automatically fill in the dates for each area.
I figure that this would be accomplished with an append query but am at a loss as to how to go about it.
Any suggestions?

 

[mp9]

UPDATE TableNameHere SET DateFieldNameHere = Now() WHERE CriteriaHere;

 

[ZmrAbdulla]

Set the field's default value to "Date()"

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.