Yes, I can do the sort the way you described, but you have to be able to copy out just the records with the latest Yearmonth within each Divord... That is what I am not able to figure out is that part
Have you tried doing a descending order Sort using your yearmonth field
as the sort key?
--
-
Garry
Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion