Join question

[FRED_EMMERICH_(Guest)]

I have 2 tables i want to join with my master table, both are date oriented table. Each of these 2 tables starts in a different month from each other. What I want to do is to be able to calculate, for each master table record, the first date from each of those tables. Is this possible? Back in the old days, it seemed like the SCANNING function was real handy for this but it is no longer available.____Also, when I right click a line on my report and go to properties, on the third tab (condition) is an item that says SCAN TABLE, what does it do? This is not in the help and nothing shows up. I am in V12.____thanks__Fred

[kfleming]

Here is an example.__Open the Sales by Salesperson Report.RRW that is the sample folder.____Then create two total fields.__The first will be a minimum of CRS_DATE that resets by SALESNO with a condition SCAN(rrslsedu)____The second is a minimum of ORDRDATE that resets by SALESNO with a condition SCAN(rrorders)____Place each of these totals on the SALESNO footer and you will see the date of the first course and the first order for each salesperson.______Kathleen__R&R Support