We are using cf with access as a database for an application here at work. I've only been using cf for about 2 weeks now so I'm a little green. I have an access table that stores project funding information in it that I need to manipulate.
here is a snippet from the table: PRJ_PointID PRJ_MainID Fund_Name 87 197 B2B 88 198 B2b 88 198 Bond 2004 88 198 B2B 89 199 CDBG And this is what I'm trying to get: PRJ_PointID PRJ_MainID Fund_Name 87 197 B2B 88 198 B2B, Bond 2004 89 199 CDBG, B2B I'm developing a report with this data and would like to have the Fund_Name field to show all the different Fund_Names so on the report I can display 1 record for each project. Be easy on me I'm a newb! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
