Search results
-
S
Problem with more than TWO criteria
:confused: Well here i am, puzzled again! I have a search form with multiple criterias ... e.g. firstname - text box, - lastname - text box, postcode - textbox. and so on. When i have any two criteria in the criteria, it works beautifully. :)... -
S
Multiple Criteria using IIF
:eek: I am looking for a method that works in query criteria (NOT HARDCODING SQL) as i am quite new to this.:eek: i have two fields for query to lookup, firstname and lastname. THE FIRSTNAME FIELD: IIf(IsNull([Forms]![frmSearch]![FirstName]),"",[Forms]![frmSearch]![FirstName]) THE...