Hello
I am working on a Invoice database for my business, I am a service provider and charge time and expenses.
I have query that returns tasks and expenses where the dates match, or if there is no expense return only the task.
I have a main Invoice report and an Expense report.
When I run the report and if there are multiple expenses for a given day the task portion of the report will print a task for each expense. I tried setting the Hide Duplicates property, but then the main task portion prints empty rows.
Thanks in advance for your help.