Search results

I have an Access 2002 table with contract_start and contract_end dates, plus annual_payment and payment_frequency (in months i.e. 0 (net 30 days), 3 (quarterly), 6 (half-yearly) and 12 (annually). I need to extract a query that will tell me when the payments are due by working back to the...

Can anyone tell me how to generate a query that shows the results for the 'Last 12 Months" based on a Date field?