Filtering in Queries (1 Viewer)

[zmichael]

I am not that adept at access and had a question. In queries I have a column for revisions. I want to try to filter the list so it will only show the latest revision. Also the revisions are labeled by letters and the occasional "A.1" label.

How could I do this?

 

[KKilfoil]

Create a Summary query rather than a Detail query.

1) Add whatever field you use to identify your documents or whatever you are tracking. Select 'Group By' in the totals row (should be the default).


2a)Add your field for revisions. In the 'totals' for this field, select 'Max' if your revision numbers ALWAYS increase.

-or-

2b) If your revision numbering is not ALWAYS consistant, use or create a revdate field and use 'Max' as above