Selecting record to report

[SueBK]

I have a very large database. One table is a version control table. The user registers each version of a monthly report. So the table contains - say 3 versions against April's report; 4 against May's report etc.

When the report is opened, it filters against a chosen month. The field the report filters against is "Report ID" (which is repeated in all my tables). The report itself is huge and comprised of a dozen or so subreports. On the title page sub report, I would like to report the absolutely latest version for the month.

When I put the date field on the report, how do I tell it to chose the last entry for the filtered month? Ie, if there's 3 records for April, I want it to return the information in 3rd record. (Again, ie, whenever the version information is updated, the information on the title page will also update).

 

[pbaldy]

A DMax might be one way:

http://www.mvps.org/access/general/gen0018.htm

 

[SueBK]

I had a look, and I've never used that format before. Not that that's especially relevant, most of what I've done in the past 4 weeks I've never done before <sigh>.

I'll have a play with it and let you know if I work it out

 

[pbaldy]

I have bad news. I've been doing this 10 years, and I still run into things I've never done before.

 

[Mr. B]

Are you guys trying to tell me that running into something that you have never done before is not normal?

I'm shocked! LOL

I have been doing Access development for almost 15 years and I still have the same experience as you guys. Something new all the time.

 

[SueBK]

Decided the easiest way around the whole thing was to add a field to my main table (actually rename an unused field), and put a box on the first form asking for the user to type in what they want to appear on the title page. Its a wee bit of double handling for the user, but ultimately a whole lot less headache for me.