>A simple case: I have a table with two relevant fields, and (month is represented as YYYYMM). This table has history for each part, starting from the current month and going back to some date in the foggy past. > >For each partno, how do I determine the last for that part nothat is NOT found in the table?
If you have a table of relevant month-years, you might do a subquery, with NOT IN, and then get a maximum on that.
Another option would be to get the first month which IS included, and then use a UDF to calculate the month before that.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)