Most recent revision query

[Delboy]

Hi All

I have a table which stores drawing types and their revisions alon
with the date completed.
I want to do a query which will only show the most recent revision.
Problem is, the revision numbers are actually letter which follow th
following convention "-,A,B,C,D,E......."
Is there a way for the query to know that "A" supersedes "-" and t
show the last drawings revision to be produced?

Any help would be greatly appreciated

Thanks
De

 

[Delboy]

Its ok, i did it by date completed!

Would be interesting to know if it could be done by letter though!

 

[Allen Browne]

So you want the query to return only the last revision of each drawing. See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

Four techniques are discussed, using stacked queries or subqueries. If
subqueries are new, here's an introduction:
http://allenbrowne.com/subquery-01.html

Once you have that working, you may still have fun with the dash. Although
Asc("-") is less than Asc("A"), Access handles dashes inconsistently:
http://support.microsoft.com/kb/271661