Query export automatically to Excel with today's date

  • Thread starter Thread starter chris23892 via AccessMonster.com
  • Start date Start date
C

chris23892 via AccessMonster.com

the more I look around for this answer, the more confused I get.

Here's what I want to do:
1.) Create a command button on my main form
2.) When this command buttom is pressed, run a query and export the output of
this querry to excel with the file name query_today's date.

I know this can be done, but all these threads are just confusing me more and
more.
Thanks!
 
never mind, figured it out. Any one know how to have the Excel file save to
the current date?
 
="Query_ & Format(Date,"yyyymmdd")

Use the above as part of the filename argument. Notice the yyyymmdd format.
That is so the files will sort in chronilogical order.
 
Back
Top