I have generated a report listing all of our employment positions code, the employees who hold and have held that position, and the date at which they took the position. The report is sorted by that date (the most recent being first). As it stands, I know of no method to format that first entry (Bold) so that it stands out above the people who have left the job. Any suggestions???

Thanks in advance!

Stacy

Is there any indicator in the record to show that the most recent person is the incumbent? I have a similar employee/position history issue and I use a Yes/No for the incumbent. When a new record is added, the old ones switch to No and the new one switches to Yes.

Based on the Yes/No, you can set the incumbent Bold.

Another option is to use a module that is called for each record, but that might get problematic depending on the size of the report. It would call the query based on the current Position number, and then create a recordset. Then it would order the recordset and return a value if the current record was the first record in the recordset, etc. Lotsa processing.

The switch in the table is the easiest solution. I am sure if there is another way to do this, other posters will chime in.

HTH


mmcdonal