Contact US

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 reports

Grouping in reports

Grouping in reports

I have a report that I need to group as follows:

Certificate A        Name    Expiration Date
                       xxxxx   xx/xx/xxxx
                        xxxxx   xx/xx/xxxx

Certificate B          xxxxx   xx/xx/xxxx
                          xxxx xx/xx/xxxx

Certificate C          xxxxx   xx/xx/xxxx

Certificate A-C is defined as a 'yes/no' field in the table.  I only want to display the records that have the value 'yes' for that particualar certificate.  I've tried to group on these fields, but it is not working right.  Does anyone have any suggestions on how I can get my report to look like the example above?

RE: Grouping in reports

Reports have filter properties that you can play with.  
I'm chicken though.  I like to always create a QUERY first, to get me the DATA I want.  Then I create a report based on that query to give me the LOOK I want.  
More flexibility, less brains... that's me.

RE: Grouping in reports

ComputiVerse tiene razon.  Definitely use queries to generate data sets and reports to organize them.

Re the certificates:  Can a given name have multiple certificates apply or are they mutually exclusive values?

You should be able to do this by combining three subqueries.  Each subquery will pull:

For A:
| ANames: Name  |A_Exp:ExpirationDate | AYesNo
                         WHERE Yes

The show field check box for the YesNo / WHERE criterion field is set to NO.

This gives a recordset of the A's.  Do the same for B & C.  Use the aliases (the part to the left of the colon) to allow distinguishing them when you pull each of these subqueries into a summary query--just pull:
 [ANames] | [A_Exp] | [BNames]| B_Exp |  etc. into this summary query and use it to build the report.  Now you don't need grouping in the report--just use the values as columns.

Please update whether this works or not!

RE: Grouping in reports

I am trying to create a total # in my Group footer field of my report.  I am doing this through code.  My code is:

Dim TotalNum As Integer

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

TotalNum = TotalNum + Me.NO_PEOPLE

End Sub

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    Me.Total = TotalNum
    TotalNum = 0
End Sub
For some reason, sometimes it loops through the same records twice.  Anyway, after every group I need the total to be zeroed out so that it can start a new running total.  Any ideas why this is happening?


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