Hi Mohammed What I know is that you can concatenate the WHERE clause of your query with "AND". For example you can write "SELECT * FROM YourTable WHERE FullName = "XXX" And Age = X And Sex = "X" etc etc. In this case the result will be only records that meet all the conditions.
I'm not very sure if this is what you are looking for Thanks Liveson ----- Original Message ----- From: Mohammed Faisal To: [email protected] Sent: Monday, 11 December, 2006 07:29 Subject: [ms_access] ANY TIPS PLS DEARS FRIENDS, I HAVE A DOUBT WHEN WORKING THROUG THE MS ACESS, HOPE ANY BODY MAY HELPS ME .THANKS IN ADVANCE I WANT TO MAKE A QUERY FOR FIVE FIELD FOR EXAMPLE A HAVE FIELD LIKE NAME, AGE, SEX, QUALIFICATION IN ONE TABLE NOW FIRST I WANT TO MAKE A QUERY FOR 1. WHERE NAME="X" AND AGE="X" 2. WHERE SEX="X" AND NAME="X" 3. WHERE NAME ="X" AND QUALIFICATION="X" 4. WHERE AGE="X" AND SEX="X" 5. WHERE AGE="X" AND QUALIFICATION="X" 6. WHERE SEX="X" AND QUALIFIATION="X" WHERE "X" IS ANY DATA IN ANY FIELD NOW I WANT TO KNOW THAT WHETHER THIS 6 QUERY CAN INTERGRATED TOGETHER TO FROM A SINGLE QUERY Thanks & Regards, Muhamed Faisal. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
