Is it possible to show the running results of a calculation on a form?
I have a form based on a table for data input. There are 6 fields called CTF1 thru CTF6 for each record.
On the form I need to show, as the user is entering the data into each field, the Total, the Average, The High and the Low number.
So for example: Field
Name DATA
CTF1 2
CTF2 6
CTF3 9
CTF4 4
CTF5 1
CTF6 3
CTF Avg 4.16 - calculated?
CTF High 9 - calculated?
CTF Low 1 - calculated?
I need this to calculate as the user is entering the data.
I hope this is clear.
Can anyone help. I'm pretty new to Access so please be patient.
Thanks and Have a Merry Christmas.
eFrank
I have a form based on a table for data input. There are 6 fields called CTF1 thru CTF6 for each record.
On the form I need to show, as the user is entering the data into each field, the Total, the Average, The High and the Low number.
So for example: Field
Name DATA
CTF1 2
CTF2 6
CTF3 9
CTF4 4
CTF5 1
CTF6 3
CTF Avg 4.16 - calculated?
CTF High 9 - calculated?
CTF Low 1 - calculated?
I need this to calculate as the user is entering the data.
I hope this is clear.
Can anyone help. I'm pretty new to Access so please be patient.
Thanks and Have a Merry Christmas.
eFrank
