Man.. I apologize for how the first message came across formatted weird.please let me try again: I have an event calendar access database with two tables (one called category with two fields: "cat_no" and "descr".. the other table is called events with many fields including two called "category" and "category2") . Events can have one or two categories and each event should be reflected on one row of the table with description, location etc. The event_no is unique for each event The Table displays as shown below, but for example event# 128 should only come up on one row with Fine Food & Beverage; Arts, Theatre & Concerts shown under Category Description.... what's wrong with my code below ?? Event no. Category Description LOCATION CATEGORY CATEGORY2 128 Fine Food & Beverage; St Michaels; 1 5 126 Sports - Youth; St Michaels; 1 2 128 Arts, Theatre & Concerts; St Michaels; 1 5 126 Arts, Theatre & Concerts; St Michaels; 1 2 <cfquery datasource="cal_endar_2" name="findcal"> SELECT * FROM events e, category c where e.category=c.cat_no or e.category2=c.cat_no </cfquery> <table> <cfoutput query="findcal" group="event_no"> <tr> <td valign="top">#event_no#</td> <td><cfoutput>#descr#;</cfoutput></td> <td>#town#</td> <td>#category#</td> <td>#category2#</td> </tr> </cfoutput> </table> Thanks in Advance Tim Laureska
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
