Updating the table

[kbrooks]

This is probably very easy to do, but I haven't figured it out.

I have a database for storing our Financial Assistance Program information. There are 3 fields that are calculated based on information the user enters in other fields. Currently these fields are calculated and displayed on the form, but not stored in the table. I know most of you would say there is no need to store it in the table, but I can't get out of this mindframe! Is there an easy way to do this? The fields do exist in my table...they're just blank.

I tried creating an update query, and having the query run when the form is updated. But that wasn't working at all.

Thanks in advance!

 

[Sohaila Taravati]

Why don't you make a query out of your table and put the same calculations in the query and call the query in your report or form. You don't even need to update your table because you have your query!

 

[kbrooks]

I guess I'm not quite sure what you mean by make a query out of my table. Maybe I'm making it harder than it really is...

 

[Sohaila Taravati]

Ok, maybe I can explain this better:

Let's say you have a field in your table called [Cost] and another called [Tax] and you want to figure the cost + the tax. You can't do this calculation in th table but you can do it in a query. Make a query out of your table and put this in the query:
TotalTax: [Cost]*[Tax]
Now when you run your query there is a field called [TotalTax] that shows the cost * tax! You can do lots of calculations in a query and make other queries out of them and use it as the source for your form or your report. I hope I am making sense.