Excel-lent friends,
I'm working on a little inventory project in which I want to transition from Excel to Access. For a given item, the prior user has created a series of columns showing anytime it is moved. For example,
1.PNG
What I want to do is combine all of those moves from columns F through O into a Remarks column in E, delimited by a comma. I created this initially:
=CONCATENATE(
F2," ",TEXT(G2,"mm/dd/yyyy"),",",
H2," ",TEXT(I2,"mm/dd/yyyy"),",",
J2," ",TEXT(K2,"mm/dd/yyyy"),",",
L2," ",TEXT(M2,"mm/dd/yyyy"),",",
N2," ",TEXT(O2,"mm/dd/yyyy"))
The problem was, for the non-blank values it gave me a 1/1/1900 result. I want to only combine if the date field has a value, and thought to use this IF statement:
=CONCATENATE(
IF(ISBLANK(G2), ??, F2," ",TEXT(G2,"mm/dd/yyyy"),",",)
IF(ISBLANK(I2), ??, H2," ",TEXT(I2,"mm/dd/yyyy"),",",)
IF (ISBLANK(K2), ??, J2," ",TEXT(K2,"mm/dd/yyyy"),",",)
IF (ISBLANK(M2), ??, L2," ",TEXT(M2,"mm/dd/yyyy"),",",)
IF (ISBLANK(O2), ??, N2," ",TEXT(O2,"mm/dd/yyyy")))
This gave me an error of too many arguments. Can any of you provide a quick help on syntax to get me the result I'm looking for?
Bookmarks