Need Help with Grouping

[dixxy]

Hello,

I have a report that groups my data (cabinet parts) by partID, then by width and then by lenght. So I can end up with more than one part with the same ID same width ,and same lenght.

My question is: Is there a way that I can list which cabinets these parts go on?

So it would should has follow:

Part Width Lenght Cabinets thses parts go on
Left part 597 895 b30,b24,b36


Thank you in advance,

Sylvain

 

[jdegeorge]

Sylvain

It'll require some VB coding on your part, but this will do it for you.

Check out this FAQ

http://www.tek-tips.com/faqs.cfm?spid=701&sfid=3499.

You'll have to play with the code to put in your table and field names, but it will definitely work. I used it for something similar. Good luck!

Jim DeGeorge

 

[jdegeorge]

Sorry

http://www.tek-tips.com/faqs.cfm?spid=701&sfid=3499

The ". You" shouldn't be part of the link.

Jim DeGeorge