Wierd Report

[travismp]

I have a database where I track test dates. I need a report to show me each persons name and their most recent test date and 2nd most recent test date.

I have included a small sample database and a word doc to show what I want the final result to look like. I do not care about the cosmetic look of the report, just the most recent and 2nd most recent test for each person.

Let me know if you have any questions from here. Thank you all so much in advance.


Travis Price

 

[mark curtis]

you can use max to get one date for each ss but i would like to know how to return the top 2 for each ss

 

[travismp]

I too would like to know this. I have messed with this thing for over three months with no such luck. I might be missing something small, but it has to be able to be done.

Hope someone finds a resolution. Thanks for the post.

T.P.

 

[mark curtis]

i know that this can be done with vba and i could write this code but it would mean creating the report direct from code. basically you would record two variables one being the last date for the ss and then check if there is another entry for the user and if only two entries then select both else select top two from all.

 

[Rich]

It doesn't need vba, it can be done in a query, search here for Top, there have been numerous posts with examples

 

[mark curtis]

Rich,

Could you download travismp example db and show me how to do this in a query?

Thanks
Mark

 

[Rich]

Need a 97vers posted first

 

[mark curtis]

well can u just create a table and use the attached txt file as data. u have the word screen shot to work from.

 

[travismp]

Thanks

That for all of the help so far. Has anyone made the report yet? If so I would love to see how this is done with or without VBA. Plase post the DB if anyone has made this work.

Thanks all.

Travismp