Grouping in reports

[MrsChicken]

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?

 

[ComputiVerse]

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.

 

[Quehay]

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!

 

[ecannizzo]

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?

Thanks!
Erica