Linking two tables with Dates

From: Zanfar Ali <zan_at_tubedale.co.uk>
Date: Tue, 20 Feb 2001 10:58:36 -0000
Message-ID: <982666736.4819.0.nnrp-14.d4f0e8b2@news.demon.co.uk>

I have two tables called work and payrate:

in work there is two fields a date and a description.

WORK

DATE                DESCRIPTION
20-Feb-2001    worked on sometething
15-Feb-2001    worked on sometething

14-Feb-2001 worked on sometething
12-Feb-2001 worked on sometething

in payrate i have a history of a persons payrates and the date it was set

PAYRATE

DATSET             RATE/Hour
16-Feb-2001        23.45
12-Feb-2001        21.45

the dateset means that from 12-Feb-2001 to 15-Feb-2001 the payrate was 21.45 and then from 16-Feb-2001 to today the payrate was 23.45.This table can have more entries.

What i need to do is to link the work table entries with the corresponding payrate...?

Any help will be highly appreciated! Received on Tue Feb 20 2001 - 04:58:36 CST