Changing the format of a field in a query

I have a query that takes two fields and combines them into one.
Rotate: [PRD] & " / " & [EAOS]

Right now the short date displays for both fields.  I want the format for both fields for this query only to display like this MMM YY.  I need the short date on other queries.

Is there a way to do it? And if so how?

Thanks
John
John SheehySecurity AnalystAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Rotate: Format([PRD], "mmm yy")  & " / " & Format([EAOS], "mmm yy")

Here's more info the various formatting for Dates:

http://office.microsoft.com/en-us/access-help/format-the-date-and-time-field-in-access-HA010341474.aspx
0
 
Rgonzo1971Connect With a Mentor Commented:
Pls try

Rotate: format([PRD], "Short Date") & " / " & format([EAOS], "Short Date")

Regards
0
 
John SheehySecurity AnalystAuthor Commented:
The solutions were right on.  The first solotuion provided, all though did work, was not what I needed.  The display was already in the short format, I was needing it in the mmm yy format.  Which the second solution provided.  So points were awarded accordingly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.