AnsweredAssumed Answered

Diplaying or reporting my information.

Question asked by dennismoorejr on Jan 20, 2017
Latest reply on Jan 20, 2017 by philmodjunk

I am in need of a solution to accomplish the following;

 

Transaction Table fields

 

ParticipantIDfk (from related particpant table)

LastName

FirstName

Employer

Transaction Amount

 

I have 100 plus record in the transaction table.

 

I am set with the transaction table.

 

I am in need of a display/report by participant along with the amount by each employer.

 

For instance John Doe has the following records (contributions on their behalf) in the transaction table

Name          Amount     Employer

John Doe     $100          ACME Manufaturing

John Doe     $100          Spacely Sprockets

John Doe     $150          ACME Manufacturing

John Doe     $25          Mels Diner

Jane Doe     $75          Mels Diner

Jane Doe      $75          ACME Manufacturing

 

The results I need are a display or out

 

Name                    ACME          Spacely               Mels                    Total

John Doe               $100              $100                    $25                    $225

Jane Doe               $75                                            $75                    $150

 

I was toying with a transaction/participant join table.  I understand the total column will be a summary of each column but I am not sure how to tag the columns Acme, Spacely, and Mel's to display by the participant.

 

Thanks for the help.

Outcomes