General information
Category:
Reports & Report designer
Title:
Grand total from repeating values in fields
I create a cursor which combines repeating information, i.e. an account no, requitsion number, total for account form
a table and equivalent total as a calucation, total for requitions, and line item valuses for a requistion. Data is pulled
together from several tables and is checking for inconsitancies in between various totals. so I could have
acct # , req # , total from table , calculated total, etc
a 1 11 10
a 2 11 10
a 3 11 10
b 5 22 20
b 5 22 20
that is totals for acct # a are 11 and 10 and differences is 1, and for account b they are 22 and 20, and difference is 2.
The grand total should be 33 and 30 and difference is 3. How can I do this (I would like results printed in table summary)?
My attemps either give me valuses for last record or sum of all values, i..e. 22, 20, 2 or 77. 70, 7.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only