>I have an sql statement that does a full join on two crosstab queries. When a record is not in the first crosstab but in the second all the fields of the cursor associated with the first crosstab have .NULL. in them but the cursor fields associated with the second crosstab has values and visaversa. How do I get the field in my report to swithch from getting it's info from one field to the next? How do I check that the value is null so I can control it?

For the expression of the field to use on the report, use:

IIF(ISNULL(FirstField),SecondField,FirstField)