Ok, this is working. I thought that if I GROUPed on all those fields I
would end up NOT getting ALL the master records but after testing it appears
to be working ok. In my summary report I will be dumping out about 15
fields from the master table, it seems like alot of fields to be GROUPing
on, is this not a good thing to do? I guess it also depends on the data..
Thanks,Adrian
-----Original Message-----
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
no, you can group by all those fields.
this will give you a list of all ponumbers, their dates, the carrier, and
the quantity shipped for each combination of these three.
chris olive, cio
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
