I have the following string in vb
strSQL = "SELECT Torque1 FROM WHERE [Torque(3Shaft,1FPM,2lb)] = '" & str & "';"
I want to extract the speicfy Torque1 field and store in a varaible. can anyone tell me how to do this. Thanks
Emily
I have the following string in vb
strSQL = "SELECT Torque1 FROM WHERE [Torque(3Shaft,1FPM,2lb)] = '" & str & "';"
I want to extract the speicfy Torque1 field and store in a varaible. can anyone tell me how to do this. Thanks
Emily
well..that sql statement isn't correct, but bascially I just want torque1 stored ina variable...
I was able to do it with DOA, but there has to be a way without opening record sets.
Try
DLookUp
/Bengt