Show unique records in Datasheet view

[btrini10]

Hello all
I have a form that allows a user to select criteria which is used to construct a where clause. The where clause is then used to filter a subform which shows in the main form's footer. The criteria on the search form includes fields that are on the many side of a number of relationships. As a result, the subform displays duplicate values for a number of records. Is there a way for me to select specific fields and not show any records where these fields are repeated? I guess it is in essence what the group function would do for a report.

 

[randy700]

Perhaps...
SELECT DISTINCT


Randy

 

[PHV]

Can't you use the DISTINCT predicate in your subform's RecordSource SQL ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[btrini10]

I think part of the issue is that I am building my where clause on fields that are not repeating on the sub-form. Therefore, using distinct does not eliminate the repeats. In order for distinct to work, I think I would have to remove all the fields that are on the many side of my one to many relationships. If I could use Distinct only for cpecific fields, but leave the others fields as part of the query so that they can be searched. Hope this makes sense.

 

[btrini10]

Hey PHV, any other ideas as to how I can accomplish this?