Case Based Critical Thinking Questions
Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices. After creating the form and viewing it in Form view, Akash needs to make some changes. Decide which options are best for Akash to use to make the necessary changes to the custom form design.
-Akash has included a calculated field in the subform which was created using a query for unpaid invoices. The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field; however, the form does not show the calculation in Form view. Which expression will solve this problem?
A)Sum([InvoiceAmt])
B)=Sum([InvoiceAmt])
C)Count([InvoiceAmt])
D)=Count([InvoiceAmt])

Question

Case Based Critical Thinking Questions
Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices.  After creating the form and viewing it in Form view, Akash needs to make some changes.  Decide which options are best for Akash to use to make the necessary changes to the custom form design.
-Akash has included a calculated field in the subform which was created using a query for unpaid invoices.  The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field; however, the form does not show the calculation in Form view. Which expression will solve this problem?
A)Sum([InvoiceAmt])
B)=Sum([InvoiceAmt])
C)Count([InvoiceAmt])
D)=Count([InvoiceAmt])

Quizplus · Accepted Answer

The equal sign (=) is needed to indicate that the calculation should be performed. Sum([InvoiceAmt]) will add up the values in the InvoiceAmt field to show the total amount of unpaid invoices in the calculated field in the subform.