Recent content by crystal2000a

  1. C

    Search form not returning records with blank fields

    Thank you!! It worked!!
  2. C

    Search form not returning records with blank fields

    Hi Experts, I'm creating a search form to filter out data based on certain inputs. My VBA code looks like: Private Sub Command18_Click() On Error GoTo errorcatch Me.Filter = "([Experiments.Log] Like ""*" & Me.Text21 & "*"") AND ([Expdate] Like ""*" & Me.Text22 & "*"") AND ([BaseSolution]...
  3. C

    Question Iif & And Function

    Hi, I have a calculated field with the formula below: Iif([Left Cathode Channel vs Cathode 1]>=0.45 And [Left Cathode Channel vs Cathode 2]>=0.45 And [Right Cathode Channel vs Cathode 1]>=0.45 And [Right Cathode Channel vs Cathode 2]>=0.45 And [Left OEE Channel vs Cathode 1]>=0.45 And [Left...
See more
Back
Top Bottom