Hello,

I'm creating something that will be used like a report card here at work. The manager will be printing this report out, sitting with his coworkers, and grading them on their duties. I have the form created that captures the data no problem at all. Here is where I am stuck...

He wants to open the report by selecting coworker (easy drop-down/query)...However, the report should at the top show the last months scores....followed by blank boxes for this scores. The next time they open it, it should show the newer scores...

I'm thinking this is really easy but i'm not connecting the dots.

Anyone able to shine some light on it for me?

See:

Get Information Associated with the Last Entry From a Table (http://www.baldyweb.com/LastValue.htm)

Hope this helps ...

Thanks for the reply, this helps.

Could I just pass the MaxDate through when I use the form to select which person's report opens up? Instead of using a separate query?