taking the last 'comma' off a text string.

[mankney]

I concatenated a groups of fields into one string field ignoring any 'null' values. Worked OK except when the last field in 'null' i get a comma. I've trimmed the field to eliminate all blanks and tried the variations of the following:

xx: IIf([x]=',',Right([NewDesc3],Len([NewDesc3])-1),[NewDesc3])
*the value of 'x' is the last character of the field.

I'm just working the the design view of Access 2007.
It sounds simple enough be i'm having no luck

[Seth Schrock]

You are close, but your 'X' needs to be the right function and the 'true' path needs the left function. Like this:

IIF(Right(NewDesc3, 1) = ',' ,
Left(NewDesc3, Len(NewDesc3) - 1),
NewDesc3)

This tests for the right most character to see if it is a ,. If it is then it gets all the characters for the length of the string except the last one.

[mankney]

You know it runs without error but doesn't display any result.

[Seth Schrock]

No matter what the data or only when there is a comma at the end or only if there isn't a comma at the end?

[mankney]

Doesn't seem to matter just doesn't return any value. I have the boxed checked just doesn't show the column. Doesn't stop for a bad expression or return an #error.

Shouldn't be this hard!

[Seth Schrock]

Create another field that just has

Right(NewDesc3, 1)

make sure that gets what you want. Then do

Len(NewDesc3) - 1

Keep working through all the individual steps and then start putting them together. Keep testing after each change and then let us know where/when it breaks.