Access query to return Month name , but not as a string

mfahadakbar

New Member
Joined
Jun 4, 2018
Messages
6
Hi Guys,

i am trying to figure out the following.

I know that if in table i have a Date/Time data type field, i can go to design view , and change the format to mmm. As a result, when table is opened up, the field would show the date as the month name, but the data type still remains as date.

I want to achieve the same with a make table query. i have mydate (1/1/2018) field, i want to create a query , that will take this field , create a table, show the month name of mydate field, but keep the format of mydate as date, not text

I have used used MonthName function and format(expression,"mmm") functions. They do change the date to month name, but the result is stored as a Text/String type, which i do not want. I want date format , yet the result are sown as month name

Any thoughts ?

Thanks
Fahad
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
In general I would not use a make table query for this (as you don't get a lot of fine control). Instead, create the table first, then do an insert/append (and of course if necessary an initial delete query to remove all records from the table). When you create the table, simply format the field as you wish. When you insert, insert the actual dates.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,608
Messages
5,765,402
Members
425,282
Latest member
Nibblesy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top