Query to count 3 components as one and show unique count

[aparnawangu]

Hi Team,

I having to generate a query where the student id should be unique.
Foreg if a have 2 records with same id but different fee components like Monthly fees,Maintenance fees n admission fees but id is 33.So the query should consider all these records as one.

Regards


Aparna

[ranman256]

Your query pulls ID# 123,
it. Will have 3 records due to the 3 components.

now make a query using your query,
keep ID field, leave out comp field,
set qry propery UNIQUE VALUES=true now you have only 1 record.