I want to change my structure in Db

  • Thread starter Thread starter Bob Vance
  • Start date Start date
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!
 
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...
 
Back
Top