Steve,
Thank you for the idea. However, it did not solve my problem.
I think what I am trying to do is rather simple, but perhaps this is not how it should be done. So I will take your hint about corners, and explain my situation. I have two tables as below.
tbl_weeks
ID_weeks autonumber
week txt
Start_dt date
End_dt date
tbl_calendar which lists the firms holidays
ID_calendar autonumber
HolidayDate date field
ID_Holiday number (actually a lookup field to another table that list all possible holidays)
I am trying to schedule the number of standard work hours (45 hrs, typically) for the next 18 weeks. The standard hours would be adjusted for any holidays that fall on a work day. As the two tables have no shared (foreign) fields, I thought that a DLookup function would work best. I just can not find any good examples of this function. But then again, perhaps there is a better way of doing this?
GaborH