Hi guys, I'm starting to learn database (Access). As a newbie for this thing, I need help urgently. I've to make a query script that need to work with Access database that contains below:

Project x -----> done by : me,she and he
Project y -----> done by : you, we and them

in access database
________________________________________
ProjectName ! Member1 ! Member2 ! Member3 !
---------------------------------------------
project x ! me ! she ! he !
---------------------------------------------
Project y ! you ! we ! them !________________________________________

Now, what I want to do is let say, a visitor would like to know what project does "me" do. So what should I do now? err..
thanks for keeping the
internet a better place.

There seems to be a flaw or gap in your database design.

What I would do is have the following tables:

tbl_PROJECTS

PROJECTID
PROJECT_NAME
PROJECT_ADDDATE
PROJECT_EDITDATE

tbl_MEMBERS

MEMBERID
FIRST_NAME
LAST_NAME
MEMBER_ADDDATE
MEMBER_EDITDATE

tbl_PROJECT_MEMBERS

PROJECTID
MEMBERID

Then you would use the following query to have people find projects "owned" by specific members:

SELECT P.*, M.MEMBERID, M.FIRST_NAME, M.LAST_NAME
FROM tbl_PROJECT_MEMBERS PM INNER JOIN tbl_MEMBERS M ON PM.MEMBERID = M.MEMBERID INNER JOIN tbl_PROJECTS P ON PM.PROJECTID = P.PROJECTID
WHERE (M.FIRST_NAME = 'form.Name') OR (M.LAST_NAME = 'form.Name')
ORDER BY M.MEMBERID

The "flaw or gap" is that you are attempting to push a flatfile construct into a relational database structure.
========================================
Buh Bye!

Cheers,
Me