Hi
Apologies if this is not in the right area but first time for posting
here.
I know how to add up amounts on a form to create a total for a line
but the database i am working on needs the total to be unique for each
row i put amounts in. What is happening is that when i put in amounts
in row 2 then it adds that along with row 1...etc etc.
On the form i put in the unbound box (called Total) the following
code...
=Sum([example1]+[example2]-[example3]) This, as stated above will
give a total amount. Example is not the name of the fields but only
used to show the format of the code i have used.
Could one of you Access gurus take the above and show me the correct
format so each row keeps its own totals; hopefully using the same
unbound box for Total on the form....unless what i require as to be
done using a query of Crosstab.
Queries are not a problem for me if they have to be used but i have
never used CrossTabs yet so please give me clear instructions if that
is the only/best route to take....or give me the form version to get
going and another method so i have something to look forward to if its
a better route to take.
Your help is appreciated.
Thankyou.
Tony