Hello,
I am having issue getting the closest value above and closest value below in table relative to another singular value in a separate table. The values also have correlating ID numbers that must be referenced.
Can someone please help?
I think this might be getting close DMin(IIf([survey]![depth]>[structure]![depth_to]),[survey]![depth],0),[structure]![depth_to],[structure]![hole_id]=[survey]![hole_id]) but it doesn't work.
Thank you,