Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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
0
John Sheehy
Asked:
John Sheehy
2 Solutions
 
Rgonzo1971Commented:
Pls try

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

Regards
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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
 
John SheehyCommunications EgineerAuthor 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now