Suad has attended:
Access Intermediate course
Cross tabs
Hello,
I've tried creating a cross tab table but can't remember how to get the total of the value i've managed to count.
RE: 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
RE: Cross tabs
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