Can you create two different labels on same report?

tperez86

New member
Local time
Today, 08:04
Joined
Feb 13, 2014
Messages
2
1 Create a report called rptCustomersByGender. The report should:
a. Print your company’s name at the top of the first page only
b. Print your data labels at the top of each page
c. Group your data by gender
d. Display all the customer information in the detail section
e. The customers should display in ascending numerical order by Last Name
f. Below the list of Female customers, it should say: “Total number of Female Customers:” and then the total number of female customers should display. Do the same for the male customers
g. The page number should display at the bottom of every page
h. The list of Female and Male customers should each print starting on a separate page.
i. Make sure the report runs without producing any errors and looks professional.

I created a report and grouped it by gender but I can't do step F. creating two different labels for each group.. Help:(:(:(
 
I don't understand about 2 different labels for each group. You only need one label, then set it to print the gender of the group you are working with. F should be done in the Group footer that you created in C. The control source of that label would look something like this:

="Total number of " & [gender] & " Customers: " & Count([gender])
 

Users who are viewing this thread

Back
Top Bottom