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

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

To display the total amount of unpaid invoices from the InvoiceAmt field in the subform, Akash needs to use the Sum function. The correct syntax for this in an expression is "=Sum([InvoiceAmt])". Therefore, option B is the best choice for Akash to use to solve the problem. Options A, C, and D are incorrect because the Sum function is required to calculate the total amount, not the Count function.

Akash Created a Custom Form for His Supervisor That Includes