Is there a way to use the DataTable.Compute Method with 2 or more filters, i have googled a bit and cant seem to come up with answer?
If not perhpas there is another way to accomplish

Thanks for any help and or insight

Current code Code:
  1. Dim Dt As Decimal = NumericUpDown1.Value
  2.                 dtlist.Rows(i)("Value") = dtsold.Compute("Max(ClosePrice)", "Distance <=" & Dt & "")

I want something like this

psuedo code Code:
  1. Dim Dt As Decimal = NumericUpDown1.Value
  2.                 dtlist.Rows(i)("Value") = dtsold.Compute("Max(ClosePrice)", "Distance <=" & Dt & " and "BuildingSize<= MAXGla"")

in other words DT.Compute(Max(Col1), where Col2<=? and Col3 <=?