Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to get sum of amount for previous 3 months (dynamically)
I have 3 tables district dist_code dist_name 11 LA 12 WA demands dist_name year demandfortheyear LA 1999 3434.44 dues dist_name month year currentdue LA 1 1999 890 LA 2 1999 656 LA 3 1999 455 LA 4 1999... -
how to get sum of amount for previous 3 months (dynamically)
I have 3 tables district dist_code dist_name 11 LA 12 WA demands dist_name year demandfortheyear LA 1999 3434.44 dues dist_name month year currentdue LA 1 1999 890 LA 2 1999 656 LA 3 1999 455 LA 4 1999...
