Search results

I have a table which lists rentals, all have start/end dates and a rental fee p.a. I want to query this table to show rentals that are effective for any part of 2 dates, [Enter Start Date] and [Enter End Date]. The purpose of this query is to calculate rental income between these 2 selected...

Hi there, I have a table with a start date and an end date for a leasing database. The lease has an annual fee, but I want to calculate what's that worth for each month of the duration of the lease. Is this possible through a query? :confused: I was going to store this data, but having read...