[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Changing the format of a field in a query

Posted on 2013-06-07
3
Medium Priority
?
356 Views
Last Modified: 2013-06-07
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
Comment
Question by:John Sheehy
3 Comments
 
LVL 54

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 400 total points
ID: 39229005
Pls try

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

Regards
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1600 total points
ID: 39229009
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
 

Author Closing Comment

by:John Sheehy
ID: 39229044
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question