Showing A Single Value

[Ricky21]

Hi,

I have my report set up. This is linked to a crosstab query. The CT query is linked to another select query. I am showing all records from one table as the column, and results are showing next to each.

I also have a field in my query which has values in, but only next to records in my column where there is a result. The problem is that I need this value to be at the top of the report for the title. Is there anyway of showing this value using expressions etc even if some of the field is displaying null values.

Thanks

Ricky

 

[andrew93]

Hi Ricky
Can you post the SQL for both queries and indicate which is the field you want at the top of the report?
Andrew