How to do it???

[k0r54]

Hi,

I have a table with 3 fields in: -
FS-ID
Availability
Relevance Date

Every month i input the availability for the id and put the relevance data as 01/06/05, 01/07/05 etc...

I am now doing a query where I want to see all the months for the line address but rather than is being:-

field1 field2 field3
fs-id availability relevance date
fs-id availability relevance date

Witht he fs-id being the same and all the months listed then the next fd-id ect..

I want it to work out how many months there are and then do it like this:-

field1 field2
fs-id availability;availability;availability;availability
fs-id availability;availability;availability;availability

So all the months there is it is in one field so it is group by the fs-id but all the months are in field 2.

Hope you understand wat i mean

Thanks
k0r54

 

[MStef]

Make a CROSSTAB QUERY.

 

[k0r54]

it doesn't seem to work, it doesn't group by the fs-id

 

[MStef]

Hello k0r54!

Look at "DemoCrostabA2000.mdb"

 

[k0r54]

i see

Thanks for you time

k0r54