var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: crosstab option
how do i do a crosstab query to pull all the valuse together. like so
Col A Col B
Blue Apple, Orange, Pear
Red Apple, Pecan
You're trying to join the Column B values into one string? There's no way to do that (that I know of) in a query in Access using only SQL. Other systems (MySQL) can do it with nonstandard syntax.
There is a Visual Basic approach. As I don't have Access handy on this machine I can't show you the code, but in short you have a query that looks like this:
The VB approach is not preferred, though.
SELECT ColA, ConCatStrings(ColA) FROM YourTable
Last edited by sco08y; 07-02-07 at 12:16.