S
Sam
The most bizarre thing...I have a subform with detail records and in the
footer of the subform there is a field that counts the primary key field of
the detail: Total = count([KBID]). I have a calculated field called Active
on the detail that results in a 0 if the contents of a status field is
"inactive" and a 1 if it is not. On the footer below it I have a calculated
field that is TotalActive=sum([Active]). All those fields were working just
fine a couple hours ago and now I get a "#error" result on the fields in the
footer. The [Active] field with the IIF statement assigning the 1 or 0
works fine but the sum statement below it no longer works.
This is insane...what have I done and what can I do to fix it? I have
double and triple checked the names of the fields (the error doesn't say
#name after all so the syntax should be right). I have done this a thousand
times. I have even closed the program and re-opened it.
footer of the subform there is a field that counts the primary key field of
the detail: Total = count([KBID]). I have a calculated field called Active
on the detail that results in a 0 if the contents of a status field is
"inactive" and a 1 if it is not. On the footer below it I have a calculated
field that is TotalActive=sum([Active]). All those fields were working just
fine a couple hours ago and now I get a "#error" result on the fields in the
footer. The [Active] field with the IIF statement assigning the 1 or 0
works fine but the sum statement below it no longer works.
This is insane...what have I done and what can I do to fix it? I have
double and triple checked the names of the fields (the error doesn't say
#name after all so the syntax should be right). I have done this a thousand
times. I have even closed the program and re-opened it.