Saving info from Form to Table

[summer]

Here is my question...
3 fields in my form are Out, In, and Grams Ink Used (which is a formula). I enter numbers into Out and In and that gives me my number in Grams Ink Used. How do I get the data in the Grams Ink Used cell to also appear in my table? All three are fields in the table, but Grams is a formula. Can I put a formula into a field's table property?

 

[Rich]

You shouldn't store the value, it can be re-calculated at any time in a query or calculated controls as you are already doing.

 

[summer]

How would I calculate it in a query? All it is, is subtracting In from Out to get Grams.

What my final result has to be for each month is a report. But I can only create a report of a query or table.

 

[Pat Hartman]

Select Out, In, Out - In As GramsInk
From YourTable;

 

[summer]

I'm sorry Pat, but you've lost me...
Do I put that string in a query or my form?
Where?

 

[summer]

OK. I figured it out. In my query I created the expression GramsInk: [Out]-[In].
That is giving me what I need. Thanks for the help.