[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

Concatenate Equivalent in MS Access

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:
=concatenate(month(A2)&-(year(A2)))

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.
0
jundizon0214
Asked:
jundizon0214
  • 2
  • 2
1 Solution
 
flavoCommented:
Use a query like this

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

Dave
0
 
jundizon0214Author Commented:
How can this be done by addiing a new field/column in the design view query?
0
 
flavoCommented:
type this

[Month Due] : Month([Due Date]) & "-" & Year([Due Date])
0
 
jundizon0214Author Commented:
although there is some error ,  i got it all work out on hte formula given by flavo... Bravo!
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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