Thanks JVFriederick. I'll take it in consideration. I'll have to learn more about VBA however. I currently hold a Junior Data Analyst position. Say, do you happen to know an excellent book I can purchase on Excel? A book that holds intermediate and advance combine in one? What about Excel...
Thanks for the quick response. Creating a separate spreadsheet is almost not an option. It's a floating report. Meaning I send it out to various VIP's and they send it out to whom it may concern. I don't want to confuse them anymore than I have to. The "Hide" function was a good...
I'm trying to trim down my report by showing only the totals. It's a huge report. One sheet contains customers with products booked and shipped adding upto 30,000 lines plus other sheets containing analysis. I only want to show the total for each customer in a worksheet. The format of...
Thank you for responding to my question. I'm working on a forecasting project of 600 customers of last years booked and shipped per week. I've extracted the raw data that I need from an ODBC table. I've created a table that contains customer numbers, booked, shipped, Distribution Center...
Is it possible in Access to design a query that will produce more than one table? If so, would anyone care to explain? What I want a query to accomplish is when everytime the customer number changes it creates separate tables. Is that possible for someone who does not have knowledge in VBA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.