I have a simple report that takes two fields (cash and scrip) and sums them together (total fare). It worked fine last month. This month the total fare is off by $110. Nothing has been modified. I don't know where to start. Any advices?
Oliver
I have a simple report that takes two fields (cash and scrip) and sums them together (total fare). It worked fine last month. This month the total fare is off by $110. Nothing has been modified. I don't know where to start. Any advices?
Oliver
1 make sure your dates are correct, your queries are correct, and any other parameters.
2 load the raw table data into excel and run a pivot table on it to get sums, then check the queries to see where they don't match
I will try that, thank you.
Oliver