How does this obstruct building report? If the query works report(s) can be
built.

lanjoudun wrote:
I think the major issue is the set up of the relationship.

One client can have many invoices (1:M)
One client can have many payment plans (1:M)
One invoice can have only one payment plan (1:1)
One client can have many classes (1:M)
One class can have many clients (1:M)
One trainer can have many classes (1:M)
One class can have many trainers (1:M)

If the query works then build a report to output the results, not save to a
table. Basic principle of relational database design, Save Raw Data,
[quoted text clipped - 5 lines]
The query does all the calculations but I'm stuck as far as moving the
information into an account table or such.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200907/1