Column totals in a crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
In the Properties of the query, set the Column Headings to a list of every
possible value, e.g.:
"F1","F2","F3","F4"

You can then add another field to the query like this:
Field: CCur(Nz([F1],0) + Nz([F2],0) + Nz([F3],0) + Nz([F4],0))
Total: Expression
Crosstab: Row Heading
 
Chris, If you are truly looking for totals of columns (not rows) then create
a report and calculate the totals there. Otherwise you may need to create
another crosstab with only the totals and then combine them in a union
query.

--
Duane Hookom
MS Access MVP


Allen Browne said:
In the Properties of the query, set the Column Headings to a list of every
possible value, e.g.:
"F1","F2","F3","F4"

You can then add another field to the query like this:
Field: CCur(Nz([F1],0) + Nz([F2],0) + Nz([F3],0) +
Nz([F4],0))
Total: Expression
Crosstab: Row Heading

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Chris said:
How do i get the totals of each column calculated and displayed in a xtab
query??

Chris
Click to expand...
Click to expand...
 
Back
Top