Summing crosstab columns on report

[Guest]

Hi

I have a table called purchase orders.

I have a crosstab query based on the this tab with uses the deilvery date as
the column heading formatted to show the month, and i use purchase order
number as the row heading.

When viewed my crosstab looks like this.


PO_Number Jan Feb Mar Apr May Jun
xxxxxxx £1000
xxxxxxx £5000
xxxxxxx £7000

and so on

I have created a report based on this crosstab and i'm trying to use a text
field to calculate the total for each month column.

I place the field in the report footer and typed =sum([Jan]) in the control
source but all i get when i run the report is #error in the box.

How do i fix this?

Thanks

 

[Duane Hookom]

1) make sure the sum is in the report footer as you stated and not in the
page footer
2) make sure the monthly columns return numeric values and not variants.

We might need to see your SQL View to provide further assistance.

 

[Guest]

Thanks so much, I'm really on dabble in access and i had mistakenly put the
field in the page footer.

I have now moved it to the report footer and the fields calculate correctly.

Thanks once again

Gillian

1) make sure the sum is in the report footer as you stated and not in the
page footer
2) make sure the monthly columns return numeric values and not variants.

We might need to see your SQL View to provide further assistance.

--
Duane Hookom
MS Access MVP
--

Hi

I have a table called purchase orders.

I have a crosstab query based on the this tab with uses the deilvery date
as
the column heading formatted to show the month, and i use purchase order
number as the row heading.

When viewed my crosstab looks like this.


PO_Number Jan Feb Mar Apr May Jun
xxxxxxx £1000
xxxxxxx £5000
xxxxxxx £7000

and so on

I have created a report based on this crosstab and i'm trying to use a
text
field to calculate the total for each month column.

I place the field in the report footer and typed =sum([Jan]) in the
control
source but all i get when i run the report is #error in the box.

How do i fix this?

Thanks

 

[Duane Hookom]

The page footer mistake happens quite regularly.

--
Duane Hookom
MS Access MVP

Thanks so much, I'm really on dabble in access and i had mistakenly put
the
field in the page footer.

I have now moved it to the report footer and the fields calculate
correctly.

Thanks once again

Gillian

1) make sure the sum is in the report footer as you stated and not in the
page footer
2) make sure the monthly columns return numeric values and not variants.

We might need to see your SQL View to provide further assistance.

--
Duane Hookom
MS Access MVP
--

Hi

I have a table called purchase orders.

I have a crosstab query based on the this tab with uses the deilvery
date
as
the column heading formatted to show the month, and i use purchase
order
number as the row heading.

When viewed my crosstab looks like this.


PO_Number Jan Feb Mar Apr May Jun
xxxxxxx £1000
xxxxxxx £5000
xxxxxxx £7000

and so on

I have created a report based on this crosstab and i'm trying to use a
text
field to calculate the total for each month column.

I place the field in the report footer and typed =sum([Jan]) in the
control
source but all i get when i run the report is #error in the box.

How do i fix this?

Thanks