Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
take the value closest to one
- Thread starter ersatz
- Start date
RobBroekhuis
Technical User
I'm not familiar with Access, so don't know how to get at the column values. But your code would probably include something like the following few lines:
loop through all values....
if abs(CurrentVal-1)<abs(ClosestVal-1) then
ClosestVal=CurrentVal
{if necessary, set pointer to current record here}
end if
.... end loop
Rob
loop through all values....
if abs(CurrentVal-1)<abs(ClosestVal-1) then
ClosestVal=CurrentVal
{if necessary, set pointer to current record here}
end if
.... end loop
Rob
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
- Locked
- Question