Hello Forum. I have a multiple report layout, everything works fine for me. The one thing I cant seem to figure out is how to total a column of numbers that are based on calculation fields. I tried everything I could think of (which isnt much ) with no luck. I think this may be a job for Execute SQL, but even with everything I read online, it's just beyond my basic skill set.
This report takes all the (in this case) fuel filters that are on the customers equipment (Amount in Use). I enter a number in the 'Amount in Stock' field. The 'Re-order Calc' then subtracts 'in use' from 'in-stock' times a multipler (to keep extra in stock) and generates an"Amount to Re-order'. This is the column I cannot figure out how to total.
Currently I take this report, export it to an Excel Spreadsheet, total it there, then print/email from Excel to place an order.
Here are 2 screenshots, (layout mode & browse mode).I'm sure I need alot more information, which I will happily provide.
Any help would be greatly appreciated.