Query Question

Question

I'll start by saying I am very new to this.

I am trying to query a DB where I have the same column with multiple data for the same record and I would like to display all of the data available in a single record rather than having the data duplicated multiple times to display the different entries (hope this makes some sense to someone)

Example:

The following columns always display the same data for the one record and don't need to be duplicated:

[Record] [Date] [UserID] [Team] [Status]

However the following field also needs to be displayed, but currently when I query it - it causes the previous mentioned fields to be duplicated and this column could have 7 or 8 different entries in it:

[Journal]

If anyone understands what I mean and has an idea how I can make it so it displays as one record I would very much appriciate it.

Example:

[Record] [Date] [UserID] [Team] [Status] [Journal1] [Journal2] [Journal3] [Journal4] [Journal5] etc.

Answer 1

See "How to get multiple records against one record based on relation?" topic at stackoverflow

http://stackoverflow.com/questions/102317/how-to-get-multiple-records-against-one-record-based-on-relation

---

Tatyana Yakushev [PredixionSoftware.com]

Answer 2

Thanks very much :)