Grouping

D

Donna

I am running a report that groups 3 different subjects: English, Writing & Folklore. I need a different footer for each subject. Is there a way to do this? If I add a group footer, the footer message shows up on all subject pages.
 
D

Duane Hookom

Could you share your table structure and some sample records? It would also
help if you could type in how you want the result to display.

--
Duane Hookom
MS Access MVP


Donna said:
I am running a report that groups 3 different subjects: English, Writing &
Click to expand...
Folklore. I need a different footer for each subject. Is there a way to do
this? If I add a group footer, the footer message shows up on all subject
pages.
 
D

Donna

Table has fields
Term, Subj, Crs, CRN, Title, Instructor, Beg, End, Day
200303 Eng 104 12345 Intro Literature Wheeler, E 900 950 MW
200303 WR 121 14886 College Comp I Montoya, C 1300 1350 MW
200303 FLR 250 15887 Intro to Folklore Sherman, S 1400 1550 U

I have the report group by Subject but I need a different footer at the end of each subject (max of 3 subjects)
 
D

Duane Hookom

What do you mean by "a different footer at the end of each subject"? Again,
it would also help if you could type in how you want the result to display.
I don't see any footers so it is impossible to make a suggestion.

--
Duane Hookom
MS Access MVP


Donna said:
Table has fields:
Term, Subj, Crs, CRN, Title,
Click to expand...
Instructor, Beg, End, Days
200303 Eng 104 12345 Intro Literature Wheeler, E 900 950 MWF
200303 WR 121 14886 College Comp I Montoya, C 1300 1350 MWF
200303 FLR 250 15887 Intro to Folklore Sherman, S 1400 1550 UH

I have the report group by Subject but I need a different footer at the
Click to expand...
end of each subject (max of 3 subjects)
 
D

Duane Hookom

I would add a "FooterText" field to a table of subjects. Then make sure your
tblSubjects is joined in your report's record source. Add a text box to the
subject footer that is bound to FooterText. This allows you to maintain this
in data rather than entering a bunch of values at run time (yuk!).

--
Duane Hookom
MS Access MVP
--

Donna said:
Eng 104 11776 Intro Literature Wheeler, Eliz 900 950 MWF P
ENG 121 11777 Intro Literature II Wheeler, Eliz 900 1050 UH K

Footer= "P = permission required for ENG grad students, K = Restricted to Majors till 9/19"

WR 198 14960 Independ Writing Proj Dresman, Paul 1500 1620 UH

Footer = "last day to add writing courses is October 1st"

FLR 250 17766 Introduction to Folklore
FLR 411 17768 Folklore & Religion

Footer = "Alpha Priority for FLR 250 Seniors: A-G - Fall, H-O-Winter, P-Z - Spring"

But I think I just figured it out but maybe you have an easier way - I
Click to expand...
could put in a group footer & then do a nested IIF statement =IIF ([Subj] =
"ENG", [Enter ENG footer],(IIF [Subj] = "WR", [Enter WR footer], (IIF [subj]
= "FLR", [Enter FLR footer]))).
 
Top