Thread: Thanks
View Single Post
  #1 (permalink)  
Old February 20th, 2006, 07:19 AM
95_rifleman 95_rifleman is offline
Registered User
 
Join Date: Feb 2006
Location: Cambridge, , United Kingdom.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Thanks

I'd like to thank mmcdonal for all the assistance in cracking my problems. Many thanks.

However, one other question. How do you create a method to look up the next largest value in a row. For instance; my table is laid out as such.

Width Height Cost
1200 1200 350.00
1250 1200 355.00
1300 1200 370.00
1200 1250 360.00
1250 1250 400.00
etc

If someone entered a value of 1210 for the width, what process would allow the calculation to go to the next highest value? The form has two text boxes, one for the width and one for the height.

Cheers
Chris:)

Reply With Quote