Search results

thanks bro! 1 reputation for you. ^^ :D its working..

UPDATE Maurice_Closeout INNER JOIN MorningBite ON (Maurice_Closeout.[MSI Number] = MorningBite.vr_partno) AND (Maurice_Closeout.vendorID = MorningBite.vendor_id) SET MorningBite.customfield1 = IIf(Maurice_Closeout.[QUANTITY AVAILABLE]<=0,"OUT OF STOCK!",IIf(Maurice_Closeout.[QUANTITY...

Hi, I have this update query. UPDATE A INNER JOIN B ON (A.[field1] = B.field1) AND (A.field2 = B.field2) B.field3 = B.[field3]+(B.[field3]-A.[field3]), B.field4 = B.[field4]+(B.[field3]-A.[field3]), B.field3 = A.[field3]; But I want it to execute after it satisfied this logical expression...

Thank you sir, Its working.. 1 reputation for u :D

Thank you Waypay. It's working :D 1 reputation for you.

oops sorry sir, im not.. Im from Philippines.. i think you misunderstood my writings :D. sorry for the wrong construction of my sentence.. if its sarcastic to you sir. anyway i just want to ask for the write syntax. im trying hard to construct my code but. still i cdnt get the right one.. thx

actually im trying to store Strings and Null Values. How to write that? thank you.

Hi I want to add the three fields then have the answer in the fourth field. Heres an example: Table: A Fields in table A field1 field2 field3 answer before updating: field1-----field2-----field3-----answer 2---------0---------1--------- after updating...

yah i want those words 'both" in the text simultaneously.. thx how to do that?

Ive tried this one but still i got errors. UPDATE MorningBite SET MorningBite.hideproduct = IIf(Instr(UCase(MorningBite.customfield1),'OUT OF STOCK','DISCONTINUED')<>0,"Y","N");

actually yes also.. but i want it in 1 query the "out of stock and discontinued". so that i can run it in one click.. then update the field.. if theres any discontinued and out of stock words. :D how to add in this query.. because i tried many times to add the word discontinued but ... i...

Hi, This is the query I have. UPDATE MorningBite SET MorningBite.hideproduct = IIf(Instr(UCase(MorningBite.customfield1),'OUT OF STOCK')<>0,"Y","N"); and this is my question. How to add another option in this area? I want to add DISCONTINUED word so that if the query runs, it will find...

:D ok thank you sir let me try that..

actually, customfield1 is not only equivalent to OUT OF STOCK but so many cases. customfield1, the field in my table, has a lot of words like IN STOCK, OUT OF STOCK, DISCONTINUED, LOW STOCK, etc. so what im trying to find out is how to write if customfield1 = OUT OF STOCK and also...

How to put a NULL here? coz if ever there's a NULL value and bro one more thing customfield1 = "OUT OF STOCK" and "DISCONTINUED"? how to write ? thx

nice. it works.. thx yah bro! btw.. may i know whats the use of Instr and the UCase? here UPDATE MorningBite SET MorningBite.hideproduct = IIf(Instr(UCase(MorningBite.customfield1),'OUT OF STOCK')<>0,"Y","N"); uhmm! is this true about your code? any OUT OF STOCK word will have Y right...

Hi, I have a problem with this query. UPDATE MorningBite SET MorningBite.hideproduct = IIf(MorningBite.customfield1='OUT OF STOCK',"Y","N"); My main purpose in this query is to make the field customfield1 as the reference and hideproduct will be the output for Y and N. Example...

Hi, I have a problem with regards to the update query I did. The problem is that my 2 Fields have empty records which are from the 2ndTable but i want to update that by using the 1st Field which has a value from the 1st Table. Ow well, heres the example: BEFORE UPDATING Field1 ------ Field2...

uhm! actually sir, its in the example. I just put CASE but not really a case statement. im using UPDATE STATEMENT here. in MS ACCESS All i need to know is that how to write it in the UPDATE statement using IIF .. coz i had already my code and i need to enhance it more. thx anyway ^_^