Thanks for taking the time to check this out... this is completely new stuff to me (teaching myself @ work)

Here is an example of a query that works for a single value i'm trying to obtain:

SELECT TOP 1 F_SGRP, F_TEST, F_VAL

FROM SGRP_TST

WHERE F_TEST=1342169992 AND F_SGRP>%F_SGRP%

ORDER BY F_SGRP DESC

I'm filtering the table "SGRP_TST" by "F_TEST" ID Number and then grabbing the value "F_VAL" from the most recent record

I need helping doing the same exact thing but using several different "F_TEST" ID's and returing several different "F_VAL"s in a single query

Any help is greatly appreciated

Thanks