Forum Discussion
Solved
Apply Rate if between Start Date and End Date
Hello Experts I have a table tblLC that has a [date] and an [amount] I have a table tblPricing with a [startdate] and [enddate] and [Rate] I have a table tblDates where I assign the [startdate] an...
you only need to put the ID of tblDates to your tblPricing table (see in design view).
i created Query 1 that joins LC table to qryPricing.
note that ms access will complain when you open in design view (query1) because
i am joining using >= and <= operator.
don't worry, you can view it in SQL view without problem.
run Query1.
HI Arnel,
Sorry for my tardy reply. I have only had a little bit of time to dig into this. I have to adjust it a little for my production db. I only posted a simple db to get the logic down. I will probably have more time in a few days and revert if any questions. I, once again, sincerely appreciate your expert intellect.
Sorry for my tardy reply. I have only had a little bit of time to dig into this. I have to adjust it a little for my production db. I only posted a simple db to get the logic down. I will probably have more time in a few days and revert if any questions. I, once again, sincerely appreciate your expert intellect.