Search results

Hi, I have a question -- I have a database that contains a PO number and two date columns -- lets call them Date1 and Date2; Now I want a third column -- Date3; which essentially will be Date1 unless Date1 is blank in which case it will be Date2. The logic is, Date3=Date1 (if Date1 is...

It does display the results when I select datasheet view, however, it still does not create the table in this case..

I am pretty sure I got THAT part!! :D does this help --> SELECT AllItems_tbl.ITEM, COWIDE11.WERKS, COWIDE11.INTRANSIT, COWIDE11.AVG3M, COWIDE11.DEP_AVG, COWIDE11.FREQUENCY, COWIDE11.STOCK, COWIDE11.OPEN_SOS, ([STOCK]+[INTRANSIT]-[OPEN_SOS])/([DEP_AVG]+[AVG3M]) AS MIOH INTO MIOH_tbl FROM...

Thanks Paul, I will try to do that. For now, I have another problem!! up until now all my create table queries were working fine. Now all of a sudden all of them give an error saying -- invalid argument. I have no idea. Can anyone throw some light on this??

Yup, the link helped! But I need the PO# to be on the MinDate query itself, since that is the only way I can link the MinDate to the Qty on the PO which is in another table. Without the PO# this crucial link is lost. Is there a way by which I can have the PO# on the MinDate query however it is...

Hi, I am doing something similar and found your information here very helpful. Thanks!! I have 3 columns in my query -- Item Number, PO Number and Due Date, I want to find the earliest due date for each item. When I do hit the E sign (TOTAL) it displays the group by for all the columns. However...