Well I think in my database design, I linked all payment plans to clients,
but now I see that clients should get invoices and those invoices are linked
to payment plans. Since from invoice to invoice a plan might change. So now
my report is able to calculate the total amount of sessions provided for each
invoice for each client, but how should I subtract a training session from an
invoice (this way if training sessions aren't completed for said invoice, the
amount left could roll over into another account, so refunds or penalties can
be served depending on each invoice). Invoices are time sensitive. Btw thank
you for all your help I know you could be wasting time on something or one
more important lol. ^.^

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

I think the major issue is the set up of the relationship.

[quoted text clipped - 11 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