Creating a repeating section

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Beth Durn (anonymous_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 08:12:43 -0700

Hello,

Does anyone know if this is possible

I have got a mail merge source in a delimited file.

The fields are name, address, transaction date,
transaction amount.

For each transaction there is one row.

Each customer may have more than one transaction so the
name & address details will be repeated several times.

I want to create a statement for the customer with their
name & address at the top, and then the transactions
listed in a table. I need a way to do some kind of
repeating section.

Thanks for you help,
Beth

Relevant Pages

  • Re: Is statement.executeBacth() a transaction?
    ... 'commit' or 'rollback' to end the transaction. ... automatically rollback to the situation before the transaction, ... I do not comprehend repeating ... the answer with a question mark as a legitimate question. ...
    (comp.lang.java.programmer)
  • Re: Regrouping data on a table (from a table of all transactions to a summary by customer)
    ... Customer ID, Transaction ID, Transaction Type, Transaction Amount, ... Each customer may have up to 6 transactions. ...
    (comp.databases.ms-access)
  • Regrouping data on a table (from a table of all transactions to a summary by customer)
    ... Customer ID, Transaction ID, Transaction Type, Transaction Amount, ... Each customer may have up to 6 transactions. ...
    (comp.databases.ms-access)
  • Re: Report based on calculations of 2 records
    ... automate the reports generation to include his payment patterns via ... ' Find using numeric data type key value? ... I am able to create a report but for the first record for each customer, ... coming in to pay at different times, the receipt number (transaction table's ...
    (microsoft.public.access.reports)
  • Re: Report based on calculations of 2 records
    ... "That is why we need to check the data entry between records to make sure users do not make errors keying in the PayFrom and PayTo fields." ... The reason for such calculations is not only to check whether the records are keyed in correctly, it allows us to monitor his payment history or pattern. ... I am able to create a report but for the first record for each customer, points to a different record as illustrated below: ... Since there are many customers coming in to pay at different times, the receipt number (transaction table's running number) will not be sequential for any one customer. ...
    (microsoft.public.access.reports)