I am creating a database for my business, I am a service provider.
I wish to incorporate travel expenses into a report, I need to relate those travel expense to the date range of the report.
The report records will consist of Task records and there may not be a cooresponding expense for a given date.
Typical ranges will be two week periods, but may extend into more. Expenses may/may not be accrued for a given date.
The problem I am having with subreports is that only the date where I have expenses are included in the report.
I am using Access 2007.
Thank you in advance for your help.