Search results

I guess there's no Max (or Min) function in VBA. Is there a simpler way to do the following, which would greatly benefit from a max function? Thanks. Option Compare Database Option Explicit Public Function PF(Distance_Feet As Variant, HF1Adj As Variant, HF2Adj As Variant, HF3Adj As Variant...

My function works except when either of two arguments, Frac_5_PARtbl or Frac_5, pass null values. If the nulls are changed to zeroes, the function works, so I've tried using the Nz() function to change the nulls to zero, but without success. The error in the immediate window is "compile error...