G
Guest
XP Pro, 2003
I am trying to develop a program for managing petty cash. I have a table
with Deposit and Payment fields.
I use a form based on the table to record deposits and payments. I want to
create a query and calculate a running balance (sum of deposits - sum of
payments), and base the form on the query so the user sees the balance of
funds when making payments.
I tried using Dsum, but I cannot figure it out -- I am not a programmer.
Thanks for any help
I am trying to develop a program for managing petty cash. I have a table
with Deposit and Payment fields.
I use a form based on the table to record deposits and payments. I want to
create a query and calculate a running balance (sum of deposits - sum of
payments), and base the form on the query so the user sees the balance of
funds when making payments.
I tried using Dsum, but I cannot figure it out -- I am not a programmer.
Thanks for any help