Report

R

richard

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Report on Parameter Query 3
formatting report using crosstab query 3
Extra space on reports 2
Calculate Subreport totals in a main report Group footer 3
Help with approach to report 5
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
Highlight user input paramter in report 0
Report criteria requested 4 times 5

Top