Duplicate Records

[Kim296]

I have read a lot of post, but haven't found quite what I'm looking for. I found the suppress if duplicate and a boolean formula (neither do what I want). I also tried grouping; it still totals all of the charges (even the one's not showing up). I'm lost at what I can do to fix this.

My Report
(this is what it looks like now)
Arrest Date, BookID, Last Name, First Name, Age, Charge
01/01/2012 26203 Smith Kim 36 DUI
01/01/2012 26203 Smith Kim 36 Open Container
01/01/2012 26203 Smith Kim 36 No Taillights
01/02/2012 26206 Stephens Gene 39 Ran Red Light

Total Records:4

(this is what I want it to look like)
Arrest Date, BookID, Last Name, First Name, Age, Charge
01/01/2012 26203 Smith Kim 36 DUI
01/02/2012 26206 Stephens Gene 39 Ran Red Light

Total Records: 2

I would like to count the BookID only once per arrest. I do not want to count the multiple charges with each BookID. Can anyone help me figure out how to get these results. Any help is much appreciated.

 

[briangriffin]

Why is DUI the only charge that you want to show for Kim?

 

[Kim296]

It doesn't matter which charge shows, as long as the BookID is only counted once. The way that I have it sorted shows the top charge first. My goal is to find the demographics of the arrest. I didn't put all of the fields in my example. For each BookID, Ihave to find whether this is a W/M,B/M, W/F, B/F and what the different age ranges are. The charge is not really important. If that helps. When I supress the duplicate BookID's it still shows the other fields in the record. I'm trying to figure out a way to only show and count the booking ID once.

 

[briangriffin]

You'll need to group by BookingID and suppress the details and group header sections. Any fields that are common to all records for a specific booking ID (such as Name or any demographic data) can be placed in the group footer.

I would suggest getting to this point, then post specifics about what you want displayed/counted.

Any fields that are not common, such as Charge, would need formulas to display what you want. You'll also need some additional groups (at a higher level than BookingID) to give you counts of age ranges, etc. However, a distinct count of Booking ID in the group footer, report footer, or both should be accurate.

 

[Kim296]

Thank you for your help Brian. I will try to group more specifically.Thanks.

 

[Charliy]

For your Total use a DistinctCount of BookId