lowest value in a multiple records

[Guest]

Hi,

Try to figure out how to single out record for a file called parent which is
multiple to one links to a student file. I need to look for the lowest value
in one of the fields in the parent record called relation. The relation has
01 for mother, 02 for father and so forth. So if any parent record has 01
relation, the record should be selected and move to the next student record.
If the parent doesn't any 01, then the next lowest value in relation 02, or
03 should be selected.

I thought of using DMin or distinctrow, but not sure how to accomplish that?
Any better ideas is greatly appreciated here.

Thanks so much in advance,
Siew-Ming

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 ways to achieve this.

 

[Guest]

Thanks so much.

After checking out the website and I found the answer. It's wonderful to
be able to get help as needed.