I have a customer table and an orders table and I need to do a few things.
1] Total just the last 2 years worth of sales orders for a customer
2] Show the last date a quote was entered into the orders table. There is field called "Type" and it's either a sale or a quote
I hope I have made myself clear.
Thanks for you help,