Need help...my noodle is baked

[glove008]

This is probably a simple task, I just don't know enough about Access at this point to complete it:

I have a large table of document numbers (DocNums) which may appear multiple times. The table also has a primary, autonumbered key (DocKey). I have another table that has a list of "special" DocNums that I want to find....what I need is a way to find the first instance of each "special" DocNum in the large table...i.e. the one with the lowest DocKey. I can't seem to make the Min or First functions do what I need.

 

[gemma-the-husky]

have a query with both tables, and join the specialdocnumref to the docnum in the docnums table. then make a totals query and select min for the dockey field.

Have you tried that?