Not Displaying a : or ,

[hawkins]

I have a subreport in which I have text boxes that combine two records into one for display. For example, one of the text boxes control sources is
=[AmpsA] & " : " & [kWA] . If there is no records what so ever it will not display the : by itself but if there is a record and isnt filled with anything, null, it displays the : by itself. I was wondering how I can get it to not display the : if both the records are empty. Any suggestions will be greatly appreciated!

[boblarson]

=[AmpsA] + " : " + [kWA]

Should do it

[rpeare]

=[AmpsA] & iif(not isnull([ampsa]) or not isnull([kwa]) ," : ",null) & [kWA]

if your only requisite is that one or the other field have a non null value this should only display the : mark if one or the other has data in it.

[ketbdnetbp]

Not really sure I understand...

"combine two records into one for display" Are you referring to records or fields?

If fields, from the same record, you might be able to use...

=IIF(IsNull([AmpsA])=True And IsNull([kWA])=True,"",[AmpsA] & " : " & [kWA])

or,

=IIF(Not IsNull([AmpsA]) And Not IsNull([kWA]),[AmpsA] & " : " & [kWA],"")

Hope this helps,

Jim

[hawkins]

Thanks for the quick replies! Works like a charm thank you!

[boblarson]

Thanks for the quick replies! Works like a charm thank you!

Which one? The one I posted should have worked because of the law of propagation of nulls.

[ketbdnetbp]

Which one? The one I posted should have worked because of the law of propagation of nulls.

Can you please explain the "law of propagation of nulls" in some detail or point me to a resource, as I would find that to be very helpful.

Thanks,

Jim

[boblarson]

This might help explain it a bit (it isn't thorough but it does help regarding concatenation):
http://windowssecrets.com/forums/sho...-concatenation

[ketbdnetbp]

Learning new things makes this forum worthwhile and exciting!

All the best,

Jim

[hawkins]

I ended up using, =IIF(IsNull([AmpsA])=True And IsNull([kWA])=True,"",[AmpsA] & " : " & [kWA]) . =[AmpsA] + " : " + [kWA] worked when the fields werent populated but if they were populated i got a #error message. This is most likely an error on my end and not the code. Thanks for the help I really appreciate it!