Stumped

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I have a report which has four different fields that have
contact names for data. Then I have a field for a customer
name for data. And the last five fields are filled with
dollar amounts for data.

This is what I'm trying to have the report come back with.

If a customer has multiple people with dollar amounts for
the same customer then have that same customer and dollar
amount show up under the different names.


Example:
Field with peoples name

Field #1 Sue Brown (tied to ABC Company)
Field #2 John Smith (tied to ABC Company)
Field #3 Paul Smith (tied to ABC Company)
Field #4 Blank

Field with customer name

Field #5 ABC Company

Field with dollar amounts

Field #6 25,000.00 (tied to ABC Company)
Field #7 50,000.00 (tied to ABC Company)
Field #8 75,000.00 (tied to ABC Company)
Field #9 Blank
Field #10 Blank

So the ABC Company has 3 dollar amount and 3 contacts tied
to it. I want to be able to see listed on the report each
contact listed with the customer name and all 3 dollar
amounts.

I've tried to group by each contact but then when I put
the customer and dollar amount field in the detail section
it only shows once.

I hope I'm making sense.

Thanks in advance for your help
 
Are you saying that one record contains the fields that
you have listed as #1 through #10? How are your tables
setup and what types of relationships are there?
 
Back
Top