G
Guest
I have the following code which is working well for me in suppressing blank
lines except I need to expand it.
=IIf([LAI]>0,"Labwork Archaeologist ",Null).
This gives me the result of "Labwork Archaeologist"
But I want it to read "Labwork Archaeologist 42 hours for a total of
$500.00" Where the 42 would be the field LAIH and the $500.00 would be
LAID. and the text would be in between. I have tried several combinations
but haven't got it. Thanks in advance for any help! Paul
lines except I need to expand it.
=IIf([LAI]>0,"Labwork Archaeologist ",Null).
This gives me the result of "Labwork Archaeologist"
But I want it to read "Labwork Archaeologist 42 hours for a total of
$500.00" Where the 42 would be the field LAIH and the $500.00 would be
LAID. and the text would be in between. I have tried several combinations
but haven't got it. Thanks in advance for any help! Paul