Cross tabs

Hi Suad

Thanks for your question

I have reviewed your question , and passed it to a colleague for his attention

We will reply shortly

Regards

Stephen

Hi Suad,

Thank you for your question and sorry about the delay in responding.

Create a new crosstab query and choose your row and column headings. After selecting the data field from the right hand box choose the Sum function.

If you have already created your crosstab, then go to Design view of the query and change the Count function to Sum in the Total Row.

I hope this answers your question.

Regards

Simon