copying results of query to excel

  • Thread starter Thread starter jomara via AccessMonster.com
  • Start date Start date
J

jomara via AccessMonster.com

I have a query that collects sales information that includes dates I am
copying this to an excel spreadsheet for another dept. I have the date set
to short date the other dept does not want to show the year in their excell
file. When we try to reformat the cell in excell it will not reformat to
month and day. Is there anyway in access to just display month and day I
need the year to be in the master database
 
I have a query that collects sales information that includes dates I am
copying this to an excel spreadsheet for another dept. I have the date set
to short date the other dept does not want to show the year in their excell
file. When we try to reformat the cell in excell it will not reformat to
month and day. Is there anyway in access to just display month and day I
need the year to be in the master database
Click to expand...

Create a Query based on the table using the Format() function to
convert the Date/Time value to String:

ExpDate: Format([datefield], "mm/dd")

and export from this Query rather than from the table.

Export ignores format settings on table fields anyway - you must use
the Format() function.

John W. Vinson[MVP]
 
Back
Top