I'd like to use DLookup to find the date a paycheck will be recieved for work performed on a specific date, "EfDate". For example, work performed on 2/25/02 will be paid in check recieved 3/15/02. I'm trying to use DLookup to find this date...it only returns the first value in the table:
Date: DLookUp("PyDate","Pay Dates","[Queries].[Ef Date].[EF DATE] BETWEEN #" & "[Tables].[Pay Dates].[PdBeg]" & "#" And "#" & "[Tables].[Pay Dates].[PdEnd]" & "#")
This only returns the first record in the Pay Dates table, regardless of the value of [EfDate]. Any ideas?? I've tried all I can think of, this is the closet I've gotten.