Removing DUPLICATE data from a SubREPORT

[RiderJon]

I have a subreport that has DUPLICATE data on it. Is there a way to remove those without doing " the make-query and appending sequence"?

Any help or suggestion will be greatly apprecaited.

 

[BillRossDenver]

Set the Recordsource of the subreport to a select query with "group by" on all fields show on the subreport

 

[RiderJon]

I donot see the "Group By" Option. All I see is "ascending and decending" in SOrt field. Am new to ACCESS, so pls. letme know if I am missing something. Thank you.

 

[chrissie1]

you have to go in th menu view and click on totals
now you will see another row appear with group by in it
and thats it "What a wonderfull world" - Louis armstrong

 

[RiderJon]

If it helps, here's part of my RecordSource:

SELECT DISTINCTROW tblProj.Solicitor, tblInv.PersonID, tblInv.CompanyID, tblInv.LastName, tblInv.FirstName, tblInv.MiddleInitial, tblInv.Salutation,

 

[RiderJon]

Ahh .... Thank you Bill and Chrissie. The total row was hidden. So, I added it and "group by" ed it. It worked!