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!
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!