Query help me thinks

[saintedmunds]

Hi

I will try and explain what Problem I am having.
I'm writing a simple TimeTable report and need help with the query behind.
The table is as below

BoxID DayID StaffID SubjectID

Ok now One or more staff can be in a subject on the same BoxID and Day ID.

So what I need is the below result

BoxID SubjectStaff DayID

But in SubjectStaff I need it to look like

French
Staff1, Staff2, Staff3

Depending on the amount of staff there is.

Any help would be great.

Cheers

 

[lespaul]

check the FAQ area for concatenation and returning single field for one to many relationship.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dhookom]

Leslie,
No direct link? You are making someone actually learn to fish rather than giving them one ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

I was busy and didn't feel like going to look for it. Besides, they ALL need to learn to fish sometime!!

les

 

[saintedmunds]

Very helpfull NOT

The reason I couldnt find it in FAQ is because I didnt know it was called "concatenation

 

[lespaul]

Ok, then what I provided was helpful. You learned something and found the FAQ.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dhookom]

There are only 30 FAQs and two of them have titles like:

one to many relationship ino a single column

and

multiple child records into a single value

I wouldn't expect you to recognize the term 'concatenate'. We put a good deal of though into the titles of the FAQs so that people will have an understanding of their functionality or purpose.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]