How do I calculate profit from start date

[Downesy]

Hello all,

I'm creating a database that keeps count of the amount of profit/loss a client has made by following our stock market advice since the date he/she joined.

I have 2 databases, "Subscribers" and "Selection_Results".

The "Subscriber" db contains the clients name, address, join date etc.

The "Selection_Results" db contains all info about the stock selection, date the selection was given, profit made, etc.

I have made a relationship between the 2 db's with called "profit_to_date", with the match file "subscriber::date_joined" with "Selection_Result::Selection_Date".

My problem is...

Instead of just matching the "date_joined" with the "Selection_Date" field, I need to match the "date_joined" date to the present day date.

Can anybody help me out with this one?

Thanks