Rates and Date Range

[Edgarr8]

Hello!

OK, I havo to calculate some fields based on a wage or rate of pay and keep a history of it.

So during a time period, this person worked so many hours at this rate and the year later rate of pay went up and so on.

How can i calculate fields in a form so it goes back to a table and grabs the correct value?

I have a little matrix witch list the "Job" a "rate of pay", "beginning date" and "ending date".

so when my they type the information in it comes up, but what can i do in my form to make it look to this martix.....dlookup? for "job", "Beg date" and 'End Date"...seemes complicated..any better ideas how i can do this?

 

[pbaldy]

A DLookup would be one way. In a query, you could join the tables together to return the relevant rate. I can't remember offhand, but that may make the query read-only

 

[SOS]

I've seen this example before which, even though it has to do with mileage, it deals with rates for a time span so it might help.

 

[pbaldy]

Bob used a DLookup to get the rate. For a large amount of data, I think the join would prove more efficient.

 

[Edgarr8]

Thank you a lot, i have to test them but once i get it working ill post my results and my opinion..