I want to change my structure in Db

B

Bob Vance

My database is an Invoice/Statement program that presently operates (In
Simple Terms) one tables for invoices another table for payments , then some
queries to give a balance due, But with this Structure 10 years down the
track my program is having to total all Invoices and Payments for the last
10 years, What I need is a monthly cut off total , then I only need to go
back say 3 months to get each month total to show on my Statement, Is there
somewhere on the net that may have a tutorial for me to see how it can been
done!
 
N

Noëlla Gabriël

Hi Bob,

for my own invoicesI have a simple solution: I have the table invoices which
is related to the Payments table (1 invoice can receive many payments), and
when the total amount payed for that invoice equals the amount due, the field
"Payed" is automatically checked (a little VBA). This way I only have to
query for those invoices with the field payed = "No" minus the already made
payments for those invoices...
 
Top