Search results

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

Thank you guys, Ok done! :D

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

thank you this one helped me a alot. btw how about a NULL VALUE? IIf([Teledynamics].[MAP]> NULL? it can be used or not? thanks again.. Added Reputation to you :D

Thank you! hi, thx for the codes. btw any codes that will not increment the values? if i clicked more than once? thank you again.. have a great day! Added Reputation for you!:D

elo! UPDATE QualityMatters INNER JOIN Teledynamics ON QualityMatters.vendor_partno=Teledynamics.[Item Number] SET Teledynamics.MAP = IIf(Teledynamics.MAP>0,QualityMatters.productprice=Teledynamics.MAP,0); this one gave my MAP field all 0 =.= how to transfer productprice to the map field? can...

oops sorry I think i just want to transfer the record from the productprice field to the map field just like in my example and btw what if its 0 or NULL? If map > 0 then productprice = map elseif map = 0 or a null value the map field will not be changed. thank you! :D

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

Thanks Alot Thank you sir! Hahaha i got it already.. Now my update query is running and in only one query unlike before.. thanks!! more power

Thank you! oh! i see. but my problem is this. I need 1 Update query that will update my two tables. The tables are QualityMatters and Teledynamics My project is how to combine these queries into 1 UPDATE Query: Queries Named as follows: 1. instock query 2. outofstock query 3. lowstock...

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