Suppressing Blank lines

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
 
G

GH

IIf([LAI]>0,"Labwork Archaeologist " & [LAIH] & " hours for a total of " &
[LAID] ,Null).
 

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

Currency format with IIF statement 4
Adding Blank Lines to a Report 0
Cancel printing blank lines 1
Redistribution of values after reaching maximum 4
Suppressing Blank Fields in a Report 4
add blank lines to report 4
Calculated Textbox not showing proper results. 4
Additional blank lines on a log sheet 1

Top