Hi all,

I've been struggling for many days trying to create a query for the following situation:

Employees are stored in a wages table with a field for name, date, wage, etc . Wages change periodically.The employee name, along with the date of change and the new wage are appended periodically.

Daily work is stored in a seperate table which has a field for the employee name, man-hours etc.

Now, I require a query, so that over a period of time, as the date changes, it keeps pace with the date of wage change, and picks up the relevant wage of the day.

Not been possible !!

This is the last thing I have done :

In wage table, indexing on date in descending order. When a particular date is encountered in the dailywork table, look for which wage-period it belongs to in the wage table.
For example, skip on the wage table in a do while loop, until the date of the dailywork table is less than the current date in the wage table. The previous date, along with the attached wage is the wage for that day/period.

Had no success at all ! Help !

Steve.