Report based on crosstab query - control sources?

[NZArchie]

Hi guys,

I was trying to redesign my report to avoid having so many DSum calculations, so I have made a single crosstab query with the various sums I want. However, I obviously didn't research well enough into how this would link to my report.

The crosstab query has 5 categories of payments, and the summed aspects of each. How can I use this as a textbox control source in a report, to show a single aspect of a single category of payment. It seems like there should be a simple way to do this. eg [GST] Where [PaymentMode] = 'New Business'

Is there such a way?

Thanks,

Arch

 

[vbaInet]

You will need to enter 'New Business' in the Column Headings property of your query.