Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Grouping in a report within a Footer

Grouping in a report within a Footer

Grouping in a report within a Footer

Dear All,

I need help in developing a small requirement in a report. Please refer to the attachment so that you can relate to the fields I will be talking about.

The report currently displays data by grouping with District -> Location -> Dept Description -> Expr2 and their respective group counts on the right.

Is this possible to implement using the Group & Sort options or can someone suggest an approach? If any additional information is required, I can surely provide it.

Thank You.

RE: Grouping in a report within a Footer

Hi Sonu84 and welcome to Tek-Tips!

If I understand correctly you want the report totals in a page footer section. Would a report footer section work for you? If you are stuck on the page footer, does your report print multiple pages?

Hook'D on Access
MS Access MVP 2001-2016

RE: Grouping in a report within a Footer

Hello Duane,

I want to add a Location Footer which will display a total no. of associates and display after grouping on F or T. As per example above, Location_0001 has two Departments and some numbers under them for F and T.

The Location Footer should display a sum of total F and T within Location group (irrespective of the department). I hope it clears what I am looking for.

Thank you.

RE: Grouping in a report within a Footer

You didn't respond regarding page footer section. I'm assuming a Location Footer section will work for you and is more appropriate.

Just add a couple text boxes with control sources like:

CODE --> ControlSource

=Sum(Abs([Your Field Name] = "T")) 

CODE --> ControlSource

=Sum(Abs([Your Field Name] = "F")) 

I'm not sure what the name of your field is but it might be Expr2. If so, you really should spend the time renaming your columns for clarity.

Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close