Hello,
I am trying to make a report based off a table that contains sales data broken down by month and year. I've got everything working well and it's grouping by route and location number. Listing the 2003 and 2004 sales for aug like I designed it to. Now in the location group footer I want it to calculate the differance for the 2 sales numbers. So if in 08/03 we did 500 in sales, and in 08/04 we did 600, it would return a differance of 100 in the group footer for that field. I'm having a hell of a time trying to get that to work and any pointers would be great. I can get it to sum and do all kinds of other functions, just can't get it to do the differance. I'm prob. over thinking it and the solution is simple, atleast I hope that's all it is.
Thanks in advance!
Note: Using Access 2000, with very little SQL / VB scripting knowledge
I am trying to make a report based off a table that contains sales data broken down by month and year. I've got everything working well and it's grouping by route and location number. Listing the 2003 and 2004 sales for aug like I designed it to. Now in the location group footer I want it to calculate the differance for the 2 sales numbers. So if in 08/03 we did 500 in sales, and in 08/04 we did 600, it would return a differance of 100 in the group footer for that field. I'm having a hell of a time trying to get that to work and any pointers would be great. I can get it to sum and do all kinds of other functions, just can't get it to do the differance. I'm prob. over thinking it and the solution is simple, atleast I hope that's all it is.
Thanks in advance!Note: Using Access 2000, with very little SQL / VB scripting knowledge
Last edited:
