working with null text

Blkblts

Registered User.
Local time
Today, 15:48
Joined
Jan 21, 2000
Messages
61
I have a report with a query that looks like this:
mbr# macro result micro microresult
1 -1 Positive 0 Null
1 0 Null -1 Neg

My report is grouped by mbr# I want them all on one line, but because there are NULLS in result field. I get a blank if I put txtresult in grouping line and I get the following if I put in detail line:
mbrgrouping
mbr# Macro Macroresult Micro result
1 -1 -1
Detail
Null
Positive
I want the Positive next to the -1 macro in grouping line. Any help is much appreciated.

Thanks
kim
 

Users who are viewing this thread

Back
Top Bottom