A dynamic Access Report.
This report grabes data from the Income Table and Expense Table between two dates that are requested from the user after the ? user requests the report.
The report will look to see what Properties, from the Property Table, had activty in between the date period. Then the report will list each properties Income, Expenses, and loss or profit. At the bottom of the report there will be a net figure containing the profit or loss of all the properties combined.
I have attached the sample Income Statement Report. I also want Report that shows all records on the Income Table between user defined dates, and all records on the Expense table between user defined dates.
I have also attached the exisitng Access Database for which the web database is to be modeled after.