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

[mfahadakbar]

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

 

[xenou]

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.