I have a Coninuous form that is based on a table with the following
fields:
ID (Text)
Qty (Number)
COMPLETE (Check Box)
Users will be going to this form and checking the COMPLETE check box as
the finish the corresponding "ID" (work order).
In the Footer of this form, I want to add text fields that make
calculations based on the info from the form/table.
For example, if there are 4 total ID's in the table, and two of them
are complete, I have a text field that shows the total ID's in the
table (=count([ID])) and the total ID's that are complete
(=abs(sum([complete]))).
The problem I have is this:
I want a text field, like the ones above, that shows the sum of the
"Qty" field where the check box is checked complete. This may be very
easy, but for some reason, I can't figure out the syntax for it. I can
create a query to do this, but when I try referencing the query in the
text field on the form, I get the #NAME! error.
Any Ideas??
THanks,
matt