Concatenating Fields 2

[lars7]

I would like to concatenate fields in a Query and divide them with a / sign. The problem is that not all the records in one of the fields have a value like:


Code Additionalcode
PMHAC34 01
PPCNM56
PSSANC62 12

And so on...

I would like the finished field to look like this:

Code
PMHAC34/01
PPCNM56
PSSANC62/12

But not like this:

Code
PMHAC34/01
PPCNM56/
PSSANC62/12


Does anyone know how to do this or an easier way to go about it?

 

[Golom]

Try

Select [Code] & IIF(IsNull(AdditionalCode),"","/" & AdditionalCode) As [NewCode], ...

 

[ZmrAbdulla]

Concat: [TableName]![Field1] & IIf([TableName]![Field2]<>"",("/" & [Table2]![Field2]),"")

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[lars7]

Thanks to you both for your quick responce. I tried:

Newcode:

 & IIf(IsNull([Additionalcode]),"","/" & [Additionalcode])

In the Query and it worked.

Once again many thanks.

 

[dhookom]

I would use:
Concat: [TableName]![Field1] & "/" + [Table2]![Field2]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]