> -----Original Message----- > From: Jay Blanchard > Sent: Tuesday, June 07, 2005 11:21 AM > You can do it in a crosstab query. There is a couple of > examples in the article on Evolt... > http://www.evolt.org/article/Using/20/26896/index.html Jay, I know you were excited to pimp your article (the article is quite good by the way), but I don't think that a cross-tab query will work given that he doesn't necessarily know the possible columns in advance. <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/