Record Card

[ccordner]

Hi

I'm trying to produce a record card based on two different tables: the leave that somebody has taken and the leave that they have booked, but not taken yet.

I have a table, "tblLeaveBooked" and a table "tblLeaveTaken".



For each person (actually only one, which will be chosen from a form), I want to show all the leave they took in the top half (in date order) and the leave they have yet to take in the bottom half (in date order).

Where's the best place to join these tables? In the report or the query?

What I'm really after, I think, is two 'detail' sections in a report. Is this possible?

Thanks
Chris.

[aytee111]

Absolutely possible. Two subreports would work great in this scenario. The main report containing the employee info, then the two subreports attached. The tables won't need to be joined, each subreport will contain only the one table. They have nothing to do with each other anyway.

[ccordner]

That's brilliant! Never realised it'd be so easy! Thanks!