By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,435 Members | 1,967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,435 IT Pros & Developers. It's quick & easy.

Calculated Text Field on a Form

P: n/a
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

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.