Currently I am setting up a database for my accounting colleague. I now have a table to hold the vouchers. I wish to have a method to perform calculations of a field (summing up the 'credits' field ) by voucher no.
to be more detail. i want to find out all the vouchers of same voucher no. and do the sum up calculation for the credit field inside every record of same voucher no.. should i use a button with script/calculation or a portal or anything to achieve it? how to? thx