Multi calcs for report: best to use query or in code of reports?
Sorry for the confusion, that was my first post. Let me explain better my situation:
I have a database to track Checks received for borrowers with student loans:
table consisting of: received date
check cut date
#customers per check
My report has to show many calculations, and I know how I want my report to look like. By the way, my table will have a large number of records, possibly up to 10,000+ records.
I need to know the most efficient/fastest way to populate my report with the calculations:
1) Do I calculate my items via a query
2) or in code of my report
3) or in a separate module, and in the code of my report call the calculations from the other module.
4) Since most of my calculations will be based on 3 or more columns from my table, is it best to use IF/Then statements in my calculations? (not really sure I know how to code for all the different calculations, guess I'll find out.)
I have attached an example of my table, and how my report is to look, along with the calculations needed. I've attached as an excel file that I zipped, I hope you can open it.
Thanks in advance for any help you see fit to provide.