Query export automatically to Excel with today's date

  • Thread starter chris23892 via AccessMonster.com
  • 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!
 
C

chris23892 via AccessMonster.com

never mind, figured it out. Any one know how to have the Excel file save to
the current date?
 
K

Klatuu

="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.
 
Top