New Access User

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

I'm new to Access (2003) databases and I have a question what most in this
group probably think is simple (stupid) but here goes. I created a database
to keep track of clients names and addresses etc. I have one table and
created a form from the table. I need to be able to do a basic math
calculation and store the total. I have a field which I'll call Initial
Funds. Each month there is a different sum of money which is added to the
Initial Funds. I named that field Additional Funds. I created a field
called Adjusted Gross Funds to store the combined value. I want to be able
to do a calculation: Initial Funds + Additional Funds = Adjusted Gross
Funds. I created an expression in the Adjusted Gross Funds field that adds
the other two fields and displays the total. So far so good. Problem is if
I change the Additional Funds the next month it changes the displayed value
back to Initial Funds plus Adjusted Funds and not adding to the Adjusted
Gross funds. I want to be able to store the field Adjusted Gross funds and
not have it change until I do another calculation. Whew..... Sorry I was so
lengthy. Do I need to create another table or form? Any help? Thanks in
advance.

PS I know I can do this in Excel but this database is eventually going to
be very large and I think Access will be a better way to manage clients,
etc.
 
Gerry,
Actually, you don't want or need to store your calculation. Just use a query
to calculate it for you any time you need it.
 
Back
Top