Error of Sum at Form!

[cap.zadi]

Hi,

I have two fields at form "TxtQtyA" and "TxtQtyB" which resulted from a Query after counting of records (Number field at Table level).

Its showing " #Error" on both horizontal sum and vertical sum.

Horizontal Sum!
=Sum(Nz([TxtQtyA],0)+Nz([TxtQtyB],0))

Vertical Sum at form footer.


=Sum(Nz([TxtQtyA],0))

Normally, this should not show the error as i have done in many other forms but whats different here then?>

[June7]

Aggregate function must reference field not control.

TxtQtyA and TxtQtyB are fields in query?

[cap.zadi]

Yes both are resulted from one field via CrossTab query.

Its showing footer sum at this query level but not at form.

[isladogs]

Remove the Sum part for the horizontal calculation

[cap.zadi]

Hi,

Its working fantastic for the horizontal sum without Sum sign.

How about the vertical sum?

I removed but its taking the value of first top line as it is.

[isladogs]

I didn't answer that as its not obvious why its not working.
That's three not's in one sentence!

Can you show the report in design view . It may help.
Also provide the report record source.

[June7]

Can Remove the NZ() as Sum() function will ignore Null.

Although that is probably not cause of issue.

Why use a form for CROSSTAB query? Cannot edit data.

[cap.zadi]

Well, its the form to just display the data at main dash board.

The cross tab query to bring the two counted results as column heading.