Ok I need to make statements but i am kinda of lost i have never taken classes or anything so im really new to all this.
I need to show invoice's that are current, over 30 days, over 60 days, over 90 days, and over 120 days. The tables that i thought i should use was customr table for all there info. Then cashrec and cashrecinvoice so i can get what they paid (to cancell that amount out of the statement if there is no balance due.). Then I figured invoice table tpo get invoice id and invoice date from it. But i can not get it to work and it is really frustrating. Please help me.

Posting questions in multiple Forums only divides the help you might receive. I did give you one possible answer in the Tables Forum, because that was where I saw it first. Queries might have been a better Forum for this particular question. If you don't know where something goes, General is always pretty safe.
David R