Crosstab query used in a report

[jgarnick]

I created a crosstab query that summarizes description amounts per lognum. (IE $12 on lognum 3445 for Postage.) The crosstab query is based on another query that combines two tables. The crosstab query works fine. I have a report that is based on this crosstab query. I am having problems with creating expressions on the report. I need to use an IIF statement for two of the columns on my report, but I need to refer to a field outside of the crosstab query, IE the type of log. I need to say if the log is x, then do this........can you add a table to the report's datasource in addition to the crosstab query--do you have to relate them???<br>
<br>
I'm a beginner crosstabber, any help would be appreciated! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[jgarnick]

I figured it out.........I just added the field for my iif statement to the crosstab query as a row heading--I didn't think it would work originally---call it a brain cramp............ <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>