sql - Grouping Column result set -


select [trader],[reference] , [type of establishment], [fruit sold], [stat licence] tablex [type of establishment]='d/03288' , [stat licence]='licenced' 

figure 1 - sample results

trader,reference , type of establishment, fruit sold, stat licnece  lady daves foxes,  d/03288, licenced, bananas , y_t_177 lady daves foxes,  d/03288, licenced, apples , y_t_177` lady daves foxes,  d/03288, licenced, pears , y_t_177` 

now how result set below in microsoft access changing sql view?

figure 1 - want ?

trader,reference , type of establishment, fruit sold, stat licnece

lady daves foxes, d/03288, licenced, bananas,apples,pear , y_t_177

suppose need pivot fruit sold column somehow ?

you looking group_concat, not exist in access.

nevertheless, there workarounds have been discussed here before.

e.g. is there group_concat function in ms-access?

hope helps r


Comments