How to eliminate comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In this field: ClientFullandTitle: [ClientFull] & ", " & [ctitle] I
sometimes don't have the person's title and the comma appears anyway - how
can I correct?

Thanks,

John
 
Take advantage of the fact that a Null value (no client title value) will
propogate through a + operation, but not through a & operation:

ClientFullandTitle: [ClientFull] & (", " + [ctitle])
 
jmuirman said:
In this field: ClientFullandTitle: [ClientFull] & ", " & [ctitle] I
sometimes don't have the person's title and the comma appears anyway - how
can I correct?
Click to expand...

ClientFullandTitle: IIf(IsNull([ctitle]), [ClientFull], [ClientFull] & ", "
& [ctitle] I )

Tom Lake
 
Thanks Ken - it's perfect!

John

Ken Snell said:
Take advantage of the fact that a Null value (no client title value) will
propogate through a + operation, but not through a & operation:

ClientFullandTitle: [ClientFull] & (", " + [ctitle])

--

Ken Snell
<MS ACCESS MVP>


jmuirman said:
In this field: ClientFullandTitle: [ClientFull] & ", " & [ctitle] I
sometimes don't have the person's title and the comma appears anyway - how
can I correct?

Thanks,

John
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create string of text from several fields eliminating last comma 6
Multiple Commas 3
Deleting commas within quotes 2
Extra comma and zero-length string 3
Serialize object to XML with nested structure 4
Count # of Characters of a certain type in a record 2
Adding a comma after a field 1
Comma in query expression 3

Back
Top