SubReport - Lined Up with Main Report Detail - Repeats any Multivalues??!?!?!

I searched the threads, but did not find this particular problem.

I have a main report. It is based on a query as follows:

Customer Table

1 to many relationship with

Orders table

In the main report, I put the customer name and address, and the Order
Date from the Orders table.

Now, I also have a subreport.

This is based on a table called
Order Types.

They are the types of orders that a given customer is to receive.
Another one to many with Customer's table.

I line the subreport up with the fields on the main report, so that it
will look like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type

It works for all customers that have 1 order type, or no order types.
I get to a customer that has multiple order types. It lists the three
types, then it list them 3 more times. Then the next customer is
listed. It looks like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
A type
B type
D type
A type
B type
D type
A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type

Why is this happening?

:-(

Thank you for any help you may be able to give.

.

Relevant Pages

  • Abuse report
    ... This is an automated response to the email you sent to the BT Customer ... All cases of abuse are taken very seriously. ... please report abuse where someone using a BT domain or a BT IP ... directly to the offender's Internet Service Provider. ...
    (uk.rec.motorcycles)
  • Re: Help ... Creating an invoice
    ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
    (microsoft.public.access.forms)
  • Re: move data from list box or combo box to another list
    ... employees is because each employee gets paid commission on the service they ... The customer and dates are ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ...
    (microsoft.public.access.forms)
  • Re: Lookup issues
    ... > Okay, I have a report that is exported from Quickbooks, and it lists a ... > customer and then one to ten account categories and amounts for each. ... > separate report. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: DBForms convert Access db and forms from Access to PHP + Mysql
    ... After conversion you'll have to use PHP tools, AJAX and work with MySql. ... say hey here's some great report writer that works with mySql. ... taking orders from a customer. ...
    (comp.databases.ms-access)
Quantcast