Export query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting a query to an excel workbook. I have a date field in the
query which is set as format dd/mm/yyyy. I would like to include an extra
column in the workbook which displays the date as mmmm. I have managed to do
this but the underlying data is still in the previous format. Is there any
way I can get the data to display and also be March 2006 for example?
 
Your post is a little confusing. You say you want a column to display the
date as mmmm, but then later say you want March 2006. So, which is it?
What you can do it create an extra Calculated column in your query to
provide the format you want. If the Field row of the query builder and in
the column location you want it to output:

OtherDate: Format([TheDateField], "mmmm")
or, if you want the year with it:
OtherDate: Format([TheDateField], "mmmm yyyy")
 
Excel doesn't always inherit the proper display format after an export from
Access. Should be simple to fix, though; select the column and format it in
the date format of your choice.

Sam
 
Back
Top