Search results

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...

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...

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...

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...

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. First Case: If Field2 and Field3 has a number > 0 Then...

Hi, This is my problem: Create a query that creates a list of records that did'nt match both in the first table and in the second table. Meaning just display the unmatched records. For Example: FirstTable.table RecNum Name Country 01 Mia...

Hi, I just want to ask how to consolidate these 3 queries with different SET into a single update query? 1st query - UpdateMAP UPDATE QualityMatters INNER JOIN Teledynamics ON QualityMatters.vendor_partno=Teledynamics.[Item Number] SET Teledynamics.map =...

Hi! I just want to know how to write this in an update query. If map > 0 then productprice = map ElseIf map = 0 then productprice <> map I have two tables: QualityMatters Table - productprice field Teledynamics Table - map field so i used INNER JOIN here do i need to use Iff...

Hi! I just want to know how to do this using an Update Query. I have two tables: QM table Tele Table I have four fields: price , vendorprice , listprice, productprice. QM table: - vendorprice , listprice , productprice Tele table: - price So I need INNER JOIN Here right? to...

Hi! I just want to know how can I convert this into MS ACCESS CODE using UPDATE query? If QA > 10 then Avail = "Instock" ElseIf QA < = 10 then Avail = "Lowstock" ElseIf QA = 0 then Avail = "Outofstock" ElseIf QA = 'discontinued' then Avail = "discontinued" End If How to use case here? QA...