i have 2 table which is project and product. product contain the list of products name. while project contain the detail of the project including the product that been used. there are 6 field of product in the project table which is product 1, product 2, product 3, product 4, product 5, and product 6. i want to create a query and search for the certain name of product and the list of project to those who used that product will come out.

now, ive create a query for that. but only product in the field 1 which is product 1 appear. others are not. help me solve this..:(

You have a design problem with the repeating product fields. You should have a related table with the products associated with a project. Read up on normalization:

http://www.r937.com/Relational.html

http://www.mdbmakers.com/forums/showthread.php?t=2583

As pbaldy said, your tables are NOT NORMALIZED WELL. Learn something about
DATABASE NERMALIZATION.