M
msandomir
I was wondering if anyone knew of a function in Access 2002 that will allow
me to look up a date within a date field, determine which start and end date
range it falls within, and then pulls the price that corresponds to that
date. However, sometimes the dates will not match exactly and in that case,
I’d like it to match the closest date.
An idea of the final result is below:
Table
(Lookup field)
Capture Date Start Date End Date Price
1/1/2000 1/1/2000 1/5/2000 500
1/10/2000 1/1/2000 1/5/2000 550
1/10/2000 1/10/2000 1/15/2000 600
My Query
(Lookup Value) (Need to pull this price)
Applicant Date Applied Price
John Smith 1/14/2006 550
me to look up a date within a date field, determine which start and end date
range it falls within, and then pulls the price that corresponds to that
date. However, sometimes the dates will not match exactly and in that case,
I’d like it to match the closest date.
An idea of the final result is below:
Table
(Lookup field)
Capture Date Start Date End Date Price
1/1/2000 1/1/2000 1/5/2000 500
1/10/2000 1/1/2000 1/5/2000 550
1/10/2000 1/10/2000 1/15/2000 600
My Query
(Lookup Value) (Need to pull this price)
Applicant Date Applied Price
John Smith 1/14/2006 550