Showing the last 2 records per person

[R32chaos]

I have a table which contains placement information for foster children and stores data based on their s/s #. For each s/s # I need to show not only the current placement, for which I have a check box field to refect that it is current, but I also need to show the record previous to that one. The previous record's "current" check box field will be blank and can be more than one. I need to have this query display the current record (based on the check box) and the one right before the current.

Is there any way to have the query show the record with CURRENT field checked as well as the record right before that one? In other words, the last two records only for each s/s #...

Your help will be grately appreciated!!

Thank you...

 

[MrQ]

Without seeing the database, I'd hazard a guess at a date field for the start of each placement? You could use this to filter on.

Q

 

[R32chaos]

Last 2 records per person

Thank you Mr. Q..your suggestion worked fantastic for me...although I had tried it, but i had to create a link within the query for that record versus the links created via subreport which was showing two records for the entire report.

Any way it worked...and I very much appreciate it!!!

 

[MrQ]

Glad I could help