Please support our ColdFusion advertiser: Programming Forums
Views: 3454 | Replies: 2
 |
•
•
Join Date: Apr 2007
Posts: 28
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
Hi all,
I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is the same, have all those records displayed together in a table row.
Is there a way to do this?
Thanks in advance!
I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is the same, have all those records displayed together in a table row.
Is there a way to do this?
Thanks in advance!
•
•
Join Date: Mar 2007
Posts: 28
Reputation:
Rep Power: 0
Solved Threads: 0
Light Poster
If you order the query by customer_number you can use cfoutput with the group attribute to group the results together.
Sorry for the poor wrapping
Sorry for the poor wrapping
------------------------------------------------- |customer_num# 1 2007-04-26 | 2007-04-16 ------------------------------------------------- |customer_num# 2 2007-03-10 ------------------------------------------------- |customer_num# 3 2007-03-20 | 2007-04-06 -------------------------------------------------
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
