Count Commas and Replace

[mattc66 via AccessMonster.com]

I have a Text feild and I want it to have a comma on the end, However there
are commas within the string already and the user may have entered a comma
already to the end.

How would I determine if there is no comma on the end and if not to add the
comma?

Thanks
Matt

 

[Douglas J Steele]

If Right(Nz(Me.MyTextField, ""), 1) <> "," Then Me.MyTextField =
Me.MyTextField & ","

 

[mattc66 via AccessMonster.com]

How would i use that in a query? I tried the IIF, but it fails.

Matt

I have a Text feild and I want it to have a comma on the end, However there
are commas within the string already and the user may have entered a comma

[quoted text clipped - 5 lines]

Thanks
Matt

 

[Douglas J Steele]

IIf(Right(Nz([MyTextField], ""), 1) <> ",", [MyTextField] & ",",
[MyTextField])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How would i use that in a query? I tried the IIF, but it fails.

Matt

I have a Text feild and I want it to have a comma on the end, However there
are commas within the string already and the user may have entered a

comma
[quoted text clipped - 5 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com

 

[mattc66 via AccessMonster.com]

How would I write the statement to remove the comma if it finds one?

How would i use that in a query? I tried the IIF, but it fails.

[quoted text clipped - 8 lines]

 

[Douglas J. Steele]

To remove all commas?

Replace([MyTextField], ",", "")

To remove a comma at the end of the string?

IIf(Right(Nz([MyTextField, ""), 1) = ",", Left([MyTextField],
Len([MyTextField])-1), [MyTextField])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

How would I write the statement to remove the comma if it finds one?

How would i use that in a query? I tried the IIF, but it fails.

[quoted text clipped - 8 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com