find nearest (higher and lower) value

[alimrb]

i have two tables named eps & price:

'eps' fields:

id

company

ReportDate

eps

'price' fields:

id

company

date

ClosePrice

in the stock exchange in my country shares closed some days before eps report date and aren't traded to some days after report day, it hasn't any rule how much days a stock was closed, maybe 1 day closed, maybe 2 months closed, i want to know the price of closed stock in the trade day just before closed day for eps reporting and just in the trade day of opening.

somebody help me please.