I have an access database that i have created for a company
I have a tbl with a list of transactions I also have a Report that lists the transactions by the criteria(which is a field). In the report footer i have a field that is a =sum(of the relevant field) to calculate the list of tranactions
now my big problem the amount in the =sum(of the relevant field) field does not equal the amount that I calculate (on a calculater)while going through each transaction on the report.
I am very confused about the problem and if anyone can help I will be very grateful
I have a tbl with a list of transactions I also have a Report that lists the transactions by the criteria(which is a field). In the report footer i have a field that is a =sum(of the relevant field) to calculate the list of tranactions
now my big problem the amount in the =sum(of the relevant field) field does not equal the amount that I calculate (on a calculater)while going through each transaction on the report.
I am very confused about the problem and if anyone can help I will be very grateful