Generate Sum of Last Orders by Customer in Microsoft Access

[@nelsonbrignas4710]

Great Job👌

[@randomvideosph-u2w]

I need this video, hope learn ms.acces with newest version🔥

[@Shadow.Dragon]

Great video, Richard! I have a db that calculates total revenue for each calendar year. I currently use VBA, but this video has given me some insight into how to use a series of queries to do the calculations!

[@RonFlimFlamFlat]

Oh-lay-thuh

[@vitom5513]

What about just giving the last sales for a specific time period (last month) to predict future sales. I believe how you did it will show sales for all dates even if a customer hasn't purchased anything for a year (or 6 months) their "last order" will be included. I think.