C
Cathi
Hi there, I like to think I am an Access mdb expert after 10 years but now I am forced to move to adp and I am having such a difficult time doing simple things in mdb in adp. I have after hours worked out most things, but now I am really stuck.
I have an order mainform, and in an order detail subform I enter a date, select a staff type, and I select a shift type. The order detail is to contract different staff types on different dates and shifts. My problem is I want a (dlookup calculation) lookup to look at the staff type, shift, and date I have selected and return the rate for that staff type, date and shift.
I have found bits of the puzzle, but would appreciate any help?
Thanks Cathi
I have an order mainform, and in an order detail subform I enter a date, select a staff type, and I select a shift type. The order detail is to contract different staff types on different dates and shifts. My problem is I want a (dlookup calculation) lookup to look at the staff type, shift, and date I have selected and return the rate for that staff type, date and shift.
I have found bits of the puzzle, but would appreciate any help?
Thanks Cathi