select from a table the highest revision number
- From: johnk@xxxxxxxxx
- Date: 31 Jan 2006 07:18:00 -0800
I have a table of items, with revision numbers. I need to extract the
items with highest revision number. The items may be listed several
times and I don't know what the highest revision number for each item
is. How do I do this?
.
- Follow-Ups:
- Prev by Date: Re: Indexs and seek need help
- Next by Date: Re: A problem occured while Microsoft Access was communicating with the Ole server or ActiveX Control
- Previous by thread: Indexs and seek need help
- Next by thread: Re: select from a table the highest revision number
- Index(es):
