Hi,
In Excel I have a column with different item numbers, like this:
112004 12-01-2007
112004 27-05-2007
113204 01-02-2007
113357 01-03-2007
Each row with item number contains som data (eg. date). I need help to a macro that should take the latest date for each unique item number and then...
Hi All,
I'm working on a forecast follow-up-tool. Unfortunately I must be some kind of query-idiot.
This is my query result untill now.
[URL=http://allyoucanupload.webshots.com/v/2003143911281666711]
My Query(design) untill now (parted)...
Hi all!
Have a look:
[URL=http://allyoucanupload.webshots.com/v/2003143911281666711]
My problem is this: Cargonumber 070003, There is also a month_of_creation from 01-04-2007 but since theres no order_qty in 01-04-2007 Access ignores it..
My SQL Looks like this:
TRANSFORM Max([Alle...
I'm working on a forecasting follow-up tool.
I've got two tables:
1: All_Forecasts (Month_of_Creation, Item_number, Month_of_Ordering and Forecast).
2: Actual_Orders (Item_Number, Order_Month And Order_Qty).
My SQL untill now looks like this:
TRANSFORM Max([Alle Forecasts].Forecast) AS...
Hi friendly helper,
I am lost!
I have 1 'Result field' on a form called 'FC8'.
This formular works in Excel, but not in Access (too many IIF's I Guess?)...
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.