How Can I Make The Database Take Data From Another Column?

I have 5 columns in ms access. They are as follows:

date_from, date_to, season_price, normal_price, actual_price.

However, I want to check if the sysdate is greater than date_from and less

than date_to then the value in the actual_price should be taken from the

season price for that record else the value should be taken from normal_price.

So, i would like to know how can do this? do i need to use visual basic?

I have no idea about visual basic. So, would like the complete way to do it.

Thanks