Access Format Date

Posted on 2014-07-15
Last Modified: 2014-07-17

I have this syntax in a crosstab ACCESS query


That returns Jan Feb Mar etc

I need two variations of this Syntax, one which returns Jan 13 Feb 14, and one that returns Jan 14 Feb 14 etc

Many thanks
Question by:Seamus2626
    LVL 11

    Accepted Solution

    Are you looking for the 3 letters of the month and the day?  If so here you go:
    Format([Date],"mmm dd")

    Open in new window

    Or 3 letters of the month then the year?  If so here you go:
    Format([Date],"mmm yy")

    Open in new window


    Author Closing Comment


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now