Search results for query: *

Thanks I'll try it later. Someone at utteraccess in the meantime had figured one way to do it. You can find the post here: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=670250 Thanks, smwabill

Leslie, Well, thanks for trying. One last thing. It's funny that the select statement will work by itself and the update and set statement will work by themselves but the whole thing will not work together. I'm really clueless as to why it keeps saying not updatable. I've even created a couple...

Yes it returns the number from apple juice Bill+

forgot to add parenthesis, but just in this corresp. Leslie, UPDATE [ORDERS TBL] SET PRODNO = (SELECT PRODNO FROM [PRODUCTS TBL] WHERE PRODNAME = "APPLE JUICE"); I took out SomeOtherCondition until this part works Thanks smwabill just added parenthesis, it was in my coding just forgot to...

Leslie, UPDATE [ORDERS TBL] SET PRODNO = (SELECT PRODNO FROM [PRODUCTS TBL] WHERE PRODNAME = "APPLE JUICE"; I took out SomeOtherCondition until this part works Thanks smwabill

Leslie, Thanks the sql as you wrote it, won't run, gives this error. "Operation must use an updatable query" maybe SET statement is problem, I put it just as you wrote it with parenthesis and all. Thanks for your continued help smwabill+

Leslie, Looking at part of your select statement select productnumber from products where productname="Apple Juice" is there a way to use this in doing an update query could you write it out for me. Thanks. smwabill+

just want to update missing product name--that's all. just tried straight update query nothing else. Thanks, smwabill+

Thanks for your answer, but it is not a new record, just one of the fields is missing information. Appreciate your continued help. smwabill+

yes, for example for some reason there was a certain product, for whatever reason that was missing from the database. 150 orders from customer(JuiceRack) are missing apple juice from certain orders and I want to do an update query and fill in the missing info. And there are a few other...

Yes, I read "The Evils of Lookup Fields in Table". So, how do you an update query on the product name in the Orders Table or is that not possible? Thanks for you quick response. smwabill+

I have an orders table and I have a product table the orders table has a lookup or link to the products table. the fields I'm linked to in the lookup is productnumber and productname the number is masked so only the name shows. but, when I try to update the productname in an update-query...