Loop through query to find value

[lafalot]

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!

[cfAllie]

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
-------------------------------------------------

[lafalot]

Yep, that worked! Thank you, CFAllie!