Recent content by Onihonker

Thank you, As I'm off for remembrance day and don't have excel at home I'll have to try it at work on Wednesday.

Here is a workbook example:

I have to calculate door pricing for my company and have no idea how to create the key formula to make it all work. I have a table that holds the base price and depending on how the door gets finished determines the sales total. I know how to make IF statements in excel but I don't know how to...

Solved I found a solution to my sorting problem. The link below helped me organize by year and month. http://www.sqlhacks.com/index.php/Dates/GroupByMonth Stopher: I found your solution combined with the above link provided the answer I needed. I thank you again for contributing.

Stopher: Thank you for helping me get this far. The query creates a report now allows the user to sort by year and it places in the month and then gives a monthly total. The problem I'm having now is it doesn't organize them by month as well. I don't know if I need to assign 1-12 values to...

I need assistance on how to create a report which accomplishes the following tasks. a)Sorts information by Month and provides a monthly total. b)Sorts information by year and provides a yearly total. c)Report must be self sustaining from one year to the next. I have a table with the columns...