Search results

Hi, I have a very large excel file that is updated monthly and left in a compacted pivottable. It has confidential information that obviously can't be shared but needs to be parsed for each individual employee and emailed in a table format so that it is easy to pull into excel or Access. I have...

Hi, I am trying to simplify my business trip planning process. I generate a list in a table which includes customer names, addresses, date, time plus some other data I use for my suppliers. I manually pull each address into google maps to determine the most efficient route. I thought about...

Hi, I am working on a forecasting tool and I need to see historical sales by supplier by customer by quarter by year. I made two crosstab queries one for quarter and one for year but am struggling to get them together with a union. The quarter query doesn't show the year and well the year...

Hi, I am relatively new at access and am trying to reduce the amount of objects in my database by combining queries or embedding queries in forms. I am breaking the "if it ain't broke don't fix it rule". I receive data updates daily which I have linked to a table in access. It requires some...

Hi All, I receive several reports daily which I want to automatically rename and save into a folder where Access will read from when I open my access file. This way it automatically gives me the latest information from those files. Example: I receive a shipping, booking, opportunity, and...

Hi, I receive multiple excel documents daily for customer sales management and am trying to automate the cleanup and put it in a format that is useful. My shipping report has the same leading rows everyday but as I ship product the trailing rows grow. What is the best way to clean this up in...

Hello, Thanks for letting me join. I found this site in the middle of searching for solutions to my access 2016 questions. I am a Sales engineer focused on wireless devices like cellular, wifi, BLE and so forth. I dabble also in antennas. I support most of the Rocky Mountain states and live in...