Compare Query

[lilmosweet]

Hello, I have a Database task to take the value of one field and check if they are the same, if they are the same then return the value of another field value at the smallest or minimum value indicated or null. Can you help me with this one. I tried to use the IIF formula but I run into a problem getting the minimum or null value from the corresponding field. Any help would be much appreciated!

The 1st field name is NIIN - I need to check for matching values and return the value of the 2nd field

The 2nd field name is MARK - this field contains null and numerical values.

I need to return the minimum or null value of each NIIN.
Thanks!

 

[namliam]

Try looking into a total's query and then using a MIN option to find what you are after.