If you can think it, Access can do it! Richard, I have heard you say this in some form or fashion many times. The DB I have been creating for 5 years or so, just for me, started out as a way to store data for quick reference with very little frills because I hadn't worked in Access for 20+ years. Over the 5 years, and with this sites help, it has evolved and aided in the success I have been able to achieve in my role as an account manager. Lately, I have wanted to automate as much as possible and one area I explored was the ability to use it to analyze an account quickly and then provide a sales briefing that I can view right before I make a sales call because I can't use Open AI per company policy. The analysis takes in multiple sales numbers(revenue, shipment count, weight, transit time, claims ratio, state to state numbers and yield), quote information, and call notes. The call briefing analyzes the analysis and gives an At A Glance for YOY & MOM for all of the sales numbers. Also, it provides win % on the quotes and can break them down by city state and zip(I work in the trucking business).  It also takes in the call notes and gives me an objective for the call, suggested talking points, and questions to ask based on the analysis all with a click of a button. IT IS SO COOL!! The best part is, I think of new things to add all the time and it can do it!!! I can't wait to see where it goes!

Thanks for what you are doing here Richard!  It is such a positive environment to learn and I am grateful I was able to stumble across it!