By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

moving studentName to the report footer

P: 2
hi guys,

I'm developing an application that filter students as pass or fail. in the table i have a field called "status" it's either fail or pass according to student grade.
the problem is in the report. my report have all students (both fail and pass) but i want the failed students to move from the table to a table at the footer of the report.
how can i do that?
Oct 15 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,324
Rather than separate tables, why not just group on the status field?
Oct 15 '07 #2

P: 2
I thought separating fail and pass students in separate tables would be easier to manipulate with, but can u tell me how to group them by status without making separate tables?
Oct 16 '07 #3

Expert Mod 10K+
P: 12,324
In report design view, click View > Sorting and Grouping. You can then group and sort on whatever variable you want. You can even group on a range of values rather than on each distinct value. And each grouping can have its own header and footer.
Oct 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.