Concatenated field

[Eddyoftheyear]

Hi All,

I have a concatenated field separated with a dash.

Example, 555145520-5556

Is there a way that the I can show the whole number all time, but when the number starts with 5200 then it only show the numbers before the dash.

Inv#: [Invoice#] & "-" & [InvoiceID]

Thanks

 

[boblarson]

Inv#: IIf(Left([Invoice#],4)=5200,[Invoice#],[Invoice#] & "-" & [InvoiceID])

And I would suggest not using # (or other special characters in your field or object names).


Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[Eddyoftheyear]

Hi Bob,

I tried it but it did not work. I still have the same information in the result. The numbers like 52000-4585 is still showing. I want to be able to see 52000

IIf(Left([Invoice#],4)=5200,[Invoice#],[Invoice#] & "-" & [InvoiceID])

Thanks

 

[PHV]

And this ?
Inv#: IIf(Left([Invoice#],4)="5200",[Invoice#],[Invoice#] & "-" & [InvoiceID])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886