I am really struggling with a way to do this.
Here is what I am trying to do and you can let me know what the best way to do this is. I am creating a report that displays the monthly cash flow for a property. I have a list of the possible expenses that might occur on the property with two columns that specify the amount that spent on each expense current month and Year to Date. Table structures are Expense(ExpenseTypeID,PropertyID,Amount,Date) ExpenseType(ExpenseTypeID,Name). I created a listbox that lists all the expenses by Name from ExpenseType but now I need to display the amounts attached to each ExpenseType and display $ - if there was no expense for that type. I hope that makes sense what I am trying to do.
Any questions please ask.