Filtering Madness

[Kipster1203]

I have a report which shows a bunch of documents. One document can have a certain number of revisions. So in the report I have a column for document name, and a column for revision number.

I need the report to only show the latest revision of each included document.

Has anyone ever done something of the like? Thanks

[Kipster1203]

I guess this must be a tough one...

[Kipster1203]

Anyone at all please????? Even if it's just an idea!

[TheShabz]

create a Filter that searches for Max(RevisionNo)?

[Kipster1203]

Where do I place this filter

[TheShabz]

http://support.microsoft.com/kb/208548

[Kipster1203]

http://support.microsoft.com/kb/208548

That link does contain any relevant information, thanks though

[pbaldy]

It would help to know your table structure, but does one or both of these queries accomplish the goal (as the source of the report)?

http://www.baldyweb.com/LastValue.htm

[Kipster1203]

This is what the design view of my report looks like

http://i47.tinypic.com/bess3d.jpg

And the revision numbers are being grabbed from the following table:

http://i48.tinypic.com/v3gmfa.jpg

Hope this helps you help me

[kimmer]

It would be helpful if you said what was the record source for the report.
To produce a list of Documents and only their most recent Rev Dates, create a query... Group By Document. Max Rev Date.

[pbaldy]

Did you try the two-query solution I posted?

[Kipster1203]

No, to tell you the truth I wasn't sure how to even use it, I'm new to all this... so thank you for your patience

[Kipster1203]

I just created a Query which sorts the data first by project, then by document name, and then by revision number. So if I could just put a filter under rev number, like Max or something, that'd be amazing... I just don't know the right command!

[Kipster1203]

Query:
http://i48.tinypic.com/30ath5g.jpg

Query Design View:
http://i48.tinypic.com/k1b94.jpg

[Kipster1203]

Actually that max command wouldnt work because it would grab the highest rev from the entire table, instead of by document.... agh

someone help, im starting to pull my hair out