Search results

care to share the solution?

I'm Back! After a number of false starts and a decent amount of research I came up with the following design. Tables: Distributors (ID, Dealer_name) Products (ID, Product_name) Period (ID, Period)(Dec12, Jan13, Feb13, Mar13) Transactions (ID, Dealer_name, Product_name, Period, Forcast, Sold)...

Howdy all, good suggestions thanks. I think I may have sent you guys of on an incorrect tangent with the use of the word "Forecasting". I should have thought of this earlier but what I'm trying to do doesn't actually do ANY forecasting, it simply totals up what the Dealers have told us they...

Howdy all, I am attempting to replace a gigantic Excel sheet (I bet you've never heard that here) that tracks sales by dealers (Excel Worksheets) for each product (Row), monthly (Columns) then rolls the info up (very clumsily) into a single per Product (still rows) monthly breakdown (still...

IT Manager outside of Detroit I know more than enough to be dangerous, but not much.