bringing query into table

[FpwL1399]

Hi, I have a table that has several fields. The ones that I want to
focus on are Date, Pre, Post, and Delta. I have about 400 pre entered
data points that only have a Date and Delta value. For demonstration
to my supervisors, I need to be able to enter data with a form for
Date, Pre, and Post. I then need to run a query on the newest data
that calculates a Delta value for the new data...it will probably be
about 15 iterations...and store them in the table with the old data.
Is there any way to do this?

To note, I understand that it is bad form to store calculated values,
but I want to stress that this is for demonstration purposes only and
my supervisors will not know what happens. In the future the pre and
post values will be the only thing to be entered and then the query
will be the only thing used to calculate delta values.

Open to suggestions.

 

[FpwL1399]

Or I have another though. is there a way that the query will bring in
the delta values from the table for ones that already have a delta
value and calculate delta values from the ones that don't?


(delta=post-pre)

 

[FpwL1399]

Never mind, I figured it out. I should work harder before I start
asking questions.

If you're wondering, I added another column to the query called

expr1: iif([Delta]=Null,[Post]-

,[Delta])

Works like a champ.