Thread: Thanks
View Single Post
  #2 (permalink)  
Old February 20th, 2006, 11:32 AM
kindler kindler is offline
Friend of Wrox
 
Join Date: Dec 2005
Location: , , .
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I believe it would be something like:

SELECT TOP 1 *
FROM tbl
WHERE tbl.Width >= Forms![frmForm]![fldWidth]
ORDER BY tbl.Width

Reply With Quote