Billing type reports

[daman2971985]

Hi,

I am trying to construct what is essentially a bill in access. The report needs to list a whole load of different data fields (name, address, customer id, letter reference etc etc) and display them on the report.

The difficult bit is that with each customer there are a number of transactions. The number of transaction depend entirely on individual circumstances and cant be predicted.

I need to find a way to create a report that will list each customer and all his details on his own page (these will be individually printed) and his own transactions (how ever many he has) as a list!

If anyone could suggest the best way to go about this it would be useful!!

Thanks in advance

[pbaldy]

Depending on the specifics of your table structure, either using the Sorting and Grouping options of the report to get the basic data into the group header and the transaction details into the detail section, or a report/subreport.

[daman2971985]

Thank you for your reply.

You gave me enough to start on and for a while it did seem to be working. However when I linked a second set of ‘ transactions’ it all fell down.

What I am trying to do can be best compared to a mobile phone bill. You would have a bill/report that is laid out as follows

a set of information such as name, address, reference numbers etc and some standard text {from master table}

A variable length table listing all calls (when, how long, who to etc) {from table b}

Some standard text, with maybe a couple of bits of user info{from master table}

A variable length table listing all SMSs (when, who to, etc) {from table c}

Some standard text, with maybe a couple of bits of user info{from master table}

A variable length table listing all internet accesses (when, how long etc) {from table d}

Some more user information {from master table}



using this analogy when I tried to set out the report like this access would put the first call followed by the first SMS followed by the complete list of internet access. Then the first call the second SMS and then the complete internet list again! And so on and so on…

I just can’t seem to get this to work! I even tried exporting and setting up a mail merge in word, but the mail merge in word doesn’t support variable length tables so you end up with tons of white space. I really don’t care how I get this to work, as long as I can get the reports made automatically ready to be printed it doesn’t make much difference what office software I have to use.