ive been looking at different ways for hours so i guess ill go back and redesign somehow.
thinking about what my customer has asked for...
we currently have a report "Report-CollectSheet" that shows 5 records per A4 page, customer loan information.
Each section shows things like loan date, payment due, any arrears, customer address and so on ,,,
the Subreport-PaymentHistory which has become the bain of my life was designed to show staff members a 12 weeks payment history,,
so! its the sum of payments received over the last 12 weeks shown in 12 weekly boxes, 1 box per week , simple ud think ,,
! i can get the data using qry but cant format it how the customer wants!
which is with dates of the week along the top and the sum of payments in for that customer underneath, well I can get this is a cross tab qry but i cant use that for a sub report because the date change. so there must be a better way.
somebody must know a better way to do this simple yet so hard task ,. as i said before this is a paid project so im happy to make a donation time spent for a working solution.