2 Replies Latest reply on Jun 15, 2006 12:21 AM by BKBK

    where clause

      Hi i have this where clause

      Season = <CFIF isdefined ("FORM.Years")>'#FORM.Years#'<CFELSE>2</CFIF>

      this works but what i need to do is if the form is not defined then = the maximum of the column

      eg if in the column was 1,1,2,2,3,3
      then = 3

      can this be done?