Crosstab query

[detdu]

hi .. this is my problem..

i have created a query based on som tables... andits supposed to look something like this

I II III IV
A 1
B
C 3,4
D 2 4
E

the thing is it doesnt show the blank areas... and it doesnt show b either since it doesnt have any data... but i want it to show everything... the second thing is that i wanna have , between the data that matches the same "criteria" any help will be a good help.. thx

 

[jrbarnett]

Detdu,

Firstly, to show rows which have no data, you need to have an outer join in your query. In the query design, right click the join and change the properties to an outer join.

To put a comma between those where there is data, you can change the specification from

fieldname

to

Fieldname & ","

but this will put it after the last one on each row as well.
It also forces Access to treat the data as text, so it becomes more difficult to perform calculations on it.

John