Can I get a query to do this?

[eggs3]

I have this table. Field 1 is date. Field 2 is "Location X". Field 3 is "Location Y". Field 4 is "Location Z"...you get the picture, only I have about 10 locations to work with.

When entering data into the table, in field 1 you put the date. Then into fields 2-4 (in this abreviated example) you enter the name of the person assigned to that location.

What I want to know is: how can I design a query to get me a report for a single person that has the dates and locations they are assigned to?

Any suggestions would be great! I'm a beginner on Access and can't figure this query out...

 

[Rich]

Isn't there a design problem here you only need one field called Location with the actual locations stored within that one field?