How to change the date format in Query View

[Kysteratwork]

Hi all,

I am wondering. In the following Design view of a query, how do I change the date tblDescription.EndDate to be only the first three letters of the month and the full year??

Description: [tblCurrencies.Currency] & " " & [tblDescription.EndDate]

Thank you so much in advance!!

Kysteratwork

 

[PHV]

Something like this ?
Description: tblCurrencies.Currency & ' ' & Format(tblCurrencies.EndDate,'mmmyyyy')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Kysteratwork]

Perfect, thanks!!