Recent content by JenO1
-
J
Using Select as a subquery within Update Query?
Perfect! Thank you so much. I can finally move forward and finish this project! -
J
Using Select as a subquery within Update Query?
I've been trying use something like UPDATE OAR SET OAR.Field = (SELECT TOP 1 [Table1]![Dose]/100 FROM [Table1] ORDER BY Abs([Table1]![Volume]-2)) WHERE (((OAR.OARSer)=1)); but I keep getting "operation must use an updateable query". Can anyone help with what I'm doing wrong? -
J
Using Select as a subquery within Update Query?
ok, this is a pre-existing database for a radiotheraphy unit in a hospital. So for a patient with a particular area of the body that's being treated, different organs are subject to various levels of radiation. They've been entering data into subforms manually for the last few years (and saving... -
J
Using Select as a subquery within Update Query?
Hi, I'm looking for a little help with nesting a query. I'm running a query in access to search a table with two fields of numbers. One field is "Dose" and the other is "Volume". Below I'm searching for the "Dose" when the "Volume" is equal to a value nearest to 2 and dividing by 100 to get the...