Hi,
Would appreciate your help in getting the right total for a formula calculated field
I am using Access 2000 table with CR 7
MY REPORT HAS FOUR COULMNS GROUPED ON ITEM TYPE
TWO COULMNS FROM THE TABLE POST.DEPIT AND POST.CREDIT
GROUPED ON POST.MATER1 AND a FORMULA CALCULATED FIELDS
@a where a formula is
sum({post.depit},{post.mater1}) - sum({post.credit},{post.mater1})
now in the highlightingexpert condition if a >= 0 it display in coulmn 3; if a<= 0 it dislay result in coulmn 4
I would like to get a total in the report footer for both
coulmn 3 and 4 so far no luck ....
When I tried to get a running total I get error message *** you cannot select this field
@a as the field summarises /reset/evaluates
ANY ADVISE
HALD5
Would appreciate your help in getting the right total for a formula calculated field
I am using Access 2000 table with CR 7
MY REPORT HAS FOUR COULMNS GROUPED ON ITEM TYPE
TWO COULMNS FROM THE TABLE POST.DEPIT AND POST.CREDIT
GROUPED ON POST.MATER1 AND a FORMULA CALCULATED FIELDS
@a where a formula is
sum({post.depit},{post.mater1}) - sum({post.credit},{post.mater1})
now in the highlightingexpert condition if a >= 0 it display in coulmn 3; if a<= 0 it dislay result in coulmn 4
I would like to get a total in the report footer for both
coulmn 3 and 4 so far no luck ....
When I tried to get a running total I get error message *** you cannot select this field
@a as the field summarises /reset/evaluates
ANY ADVISE
HALD5