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!
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
-------------------------------------------------
|customer_num# 1 2007-04-26
| 2007-04-16
-------------------------------------------------
|customer_num# 2 2007-03-10
-------------------------------------------------
|customer_num# 3 2007-03-20
| 2007-04-06
-------------------------------------------------Yep, that worked! Thank you, CFAllie!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.