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
Post a Comment