Asked by knmk
Montel needs to add a calculated field into a report that he has built that will show the total sale price of items sold in a given month. Which type of control should he add in Design view?
control box
text box
label
subreport
All Answers 1
Answered by
GPT-5 mini
AI
Text box.
Add a Text Box in Design view and set its Control Source to a calculation (for example =Sum([SalePrice]) or =Sum([Quantity]*[UnitPrice])). Place it in the group footer for the month (or use a group-level aggregate) and format as Currency.
Add a Text Box in Design view and set its Control Source to a calculation (for example =Sum([SalePrice]) or =Sum([Quantity]*[UnitPrice])). Place it in the group footer for the month (or use a group-level aggregate) and format as Currency.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.