Recent content by seabass

Multiple Criteria Solved hello everyone! Here is the completed search using multiple criteria with wildcards (NOT HARDCODING SQL) just in access queries:) This MS Access help center is great. im loving it! Attachment below

:D That was not the most obvious error "" not being null therefore never true. Thank you ever so much for giving me those pointers EMP Here, i have posted the finished article for those who need the same answer. I don't know of any other forum which now has working multiple criteria search...

The requested example search database Hi EMP ;) This is simply bizzarre! I can't see the woods for the trees with this problem. I have 3 criteria that lookup for search in the customers query. These are; IIf(IsNull([Forms]![frmSearch]![FirstName]),True,[FirstName] Like "*" &...

: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. :)...

A great big THANKYOU Hello Jon, It worked, but please read on... ;) I have to admit that I had been on this problem for a long time. Too long! :rolleyes: I looked at the code you provided and I realise the main part I got wrong was not linking the criteria in question to the expression...

: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...