Concatenate Equivalent in MS Access

Posted on 2005-04-13
Last Modified: 2011-10-03
Hi Experts,

I know how to use the concatenate formula in excel for the following scenario:

A                       B
Due Date            Month Due
14-APR-05         4-2005

the formual is use in excel to get the month due is:

Now the file is to big to do it in excel so i use MS Access, problem is i dont know the formula to get the Month Due result in excel that i need. Kindly help. Thanks.
Question by:jundizon0214
    LVL 34

    Expert Comment

    Use a query like this

    SELECT Month([Due Date]) & "-" & Year([Due Date]) AS [Month Due], [Due Date]
    FROM tblYourTableName;


    Author Comment

    How can this be done by addiing a new field/column in the design view query?
    LVL 34

    Accepted Solution

    type this

    [Month Due] : Month([Due Date]) & "-" & Year([Due Date])

    Author Comment

    although there is some error ,  i got it all work out on hte formula given by flavo... Bravo!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    754 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

    21 Experts available now in Live!

    Get 1:1 Help Now