If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report
I have a table which has the following fields for each record
[HouseNo] [Street] [MortPmtDate] [MortMthlyPmt] [RentDueDate] [MonthlyRent] I wish to create a report which will group the [RentDueDate] and [MortPmtDate] and display the records accordingly. The values in the [RentDueDate] and [MortPmtDate] can be the same values but will differ within the same record is [RentDueDate] =5(th) and [MortPmtDate]=30(th) So what I am looking for in the report is as follows Grouping Section 1st of Month Detail Section House1Mortgage £250.00 House2RentIncome £300.00 2nd of month House2Mortgage £250.00 House1RentIncome £250.00 Obviously the values shown above are made up but hopefully you can see the sort of format I am looking for. any help would be great and and if not clear above please ask |
Thread Tools | |
Display Modes | |
|
|