 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2005Syntax Error - Comma
I have failed to get this working: =IIf([CharterMember]=-1,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy ")","CharterMember ") Error message reports syntax error, comma etc. What have I missed? Thanks, Robin looks like the problem is not a misplaced comman, but an extra double quote after the Format function's closing parenthesis. try =IIf([CharterMember]=-1,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy "),"CharterMember") hth > I have failed to get this working: > [quoted text clipped - 8 lines] > > Robin Tina, Thanks. Nikos found the same error for me. Message to Nikos repeated here: I have another problem; The final requirement is to concatenate the "ClubName" and the "DateJoined" fields and to add the literal 'Charter Member' when the Yes/No field "CharterMember" is set to Yes. This is my attempt at the final version: =IIf([CharterMember]=0,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy "),"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy ")CharterMember ") which is not accepted. The text box reverts to the original code. Cheers, Robin >looks like the problem is not a misplaced comman, but an extra double quote >after the Format function's closing parenthesis. [quoted text clipped - 17 lines] >> >> Robin Stop the presses. I did it myself: =IIf([CharterMember]=0,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy "),"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy ")& " CharterMember ") Thanks for your help. Robin >Tina, > [quoted text clipped - 41 lines] >>> >>> Robin good job! :) > Stop the presses. > [quoted text clipped - 53 lines] > >>> > >>> Robin Robin, The error is not the comma, it's the quote right before it, which must be removed. Try this: =IIf([CharterMember]=-1,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy "), "CharterMember ") HTH, Nikos > I have failed to get this working: > [quoted text clipped - 8 lines] > > Robin Nikos, Thanks, that was the problem but it was stage one. The final requirement is to concatenate the "ClubName" and the "DateJoined" fields and to add the literal 'Charter Member' when the Yes/No field "CharterMember" is set to Yes. This is my attempt at the final version: =IIf([CharterMember]=0,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy "),"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy ")CharterMember ") which is not accepted. The text box reverts to the original code. Cheers, Robin >Robin, > [quoted text clipped - 19 lines] >> >> Robin |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.