I have sifted through this forum to make sure that I am not repeating a question and I have looked at the FAQ's, but I could not find a similar situation. So here goes.
Created a form from ONE table. Need to do an average on a 4 similar fields, then another average on 2 other similar fields.
I created a query based on this table and created the following expression:
groAvg=Expr1: Avg(([groHAC0400]+[groHAC2200]+[groHAC1000]+[groHAC1600])/4)
and the next expression is:
pbAvg=Expr1: Avg(([pbHAC0400]+[pbHAC1600])/2)
These are in the same query grid. I get the averaging to work quite nicely in the form. YA HOOOOOO! however.............
Now I am not able to enter data. I get this error message RECORDSET NOT UPDATEABLE.
Now I have read and tried to understand the HELP... usually it HELPS me but I am daft at this one.
What in the world am I doing to cause myself such grief! X-)
TIA.... Niki [sig][/sig]
Created a form from ONE table. Need to do an average on a 4 similar fields, then another average on 2 other similar fields.
I created a query based on this table and created the following expression:
groAvg=Expr1: Avg(([groHAC0400]+[groHAC2200]+[groHAC1000]+[groHAC1600])/4)
and the next expression is:
pbAvg=Expr1: Avg(([pbHAC0400]+[pbHAC1600])/2)
These are in the same query grid. I get the averaging to work quite nicely in the form. YA HOOOOOO! however.............
Now I am not able to enter data. I get this error message RECORDSET NOT UPDATEABLE.
Now I have read and tried to understand the HELP... usually it HELPS me but I am daft at this one.
What in the world am I doing to cause myself such grief! X-)
TIA.... Niki [sig][/sig]