Where you can keep the sum([Sales]) to calculate the totals for each month?
Tap an option to check yourself.
Answer: C) In the month group footer section
In Microsoft Access, if you want to calculate the total sales for each month, place the =Sum([Sales]) expression in the Month Group Footer section.
The Group Footer appears at the end of each group (in this case, each month), so Access calculates and displays a separate sales total for every month.
Microsoft Access मा प्रत्येक महिनाको बिक्री रकमको जम्मा (Total Sales) निकाल्न =Sum([Sales]) expression लाई Month Group Footer Section मा राखिन्छ।
यसले प्रत्येक महिनाको Group समाप्त भएपछि सोही महिनाको कुल बिक्री रकम देखाउँछ।
Exam Tip:
- Group Footer: प्रत्येक Group को subtotal निकाल्न।
- Report Footer: सम्पूर्ण Report को Grand Total निकाल्न।
- Page Footer: प्रत्येक पृष्ठको तल जानकारी देखाउन।