Thanks Bob!
I have been able to use the code but there is a catch.
Code:
SELECT Cons.Import_ID, Cons.Description, Cons.[Brand_ID>], Cons.[Supplier_ID>], Cons.BigQty, Cons.SmallQty, Cons.BankValue, Cons.ActuValue
FROM Cons
WHERE (((Cons.Import_ID) Like "*" & Forms!Form1!Station & "*" And (Cons.Import_ID) Like "*" & Forms!Form1!Catagory & "*") And ((Cons.Description) Like "*" & Forms!Form1!Des & "*") And ((Cons.[Brand_ID>])=Forms!Form1!Brand_ID Or Forms!Form1!Brand_ID is null));
I have added one more field to the query criteria - "Brnad_ID" and adjusted the code accordingly to fit that criteria. This field is a foreign key to my query table "Cons" which takes its value form the lookup table "_BrandLookup". The value of the criteria if fed from the "Brand_ID" combobox of the form.
The problem is, in my query table (Cons) if any of the record of any query field has empty value (ie NULL), then the query SOMETIMES avoids that record. Although I can't recon on that as I am a newbie to the DB designing world and this is my first project. It'll be helpful to me if you have any conclusive theory on that and could share with me.
Also, can you PLEASE help me by answering the following 2 questions?
A. What is the difference between "ISNULL" and "IS NULL"?
B. Is there any drawback of using foreign key as query criteria?
As "Brnad_ID" which I have later added is a foreign key.
Thanks in advance.