AnsweredAssumed Answered

Relational Reports

Question asked by ScottLaird on Jun 29, 2011
Latest reply on Jun 29, 2011 by philmodjunk

Title

Relational Reports

Post

I'm a bit stuck and looking for advice.

I have a database with Multiple Tables.

Table 1:  Contains Account Numbers (key) along with fields for account plan names.  (Large list 200k records)

Table 2:  Contains Account Numbers (key) along with field for Promo Account Names (Small List 1k records)

Table 3-8 (1 file for every month) Contain Account Numbers (key) along with Account Balance, Service Fees charged, Interest charged.  (Large files 100k records)

I would like to create a summary report that looks like this that can be filtered by month.

Plan 1: Average Account Balance Average Fees Charged Average Interest Charged

Promo A

Promo B

Promo C

Promo D

No Promo

Plan 2: Average Account Balance Average Fees Charged Average Interest Charged

Promo A

Promo B

Promo C

Promo D

No Promo

Any suggestions or direction would be much appreciated.

Outcomes