Reply to thread

Message: [QUOTE="Alexandre Saillant, post: 3466656"] Hello, I have 2 database, One with vehicule data and another with All the option each vehicule has. I want to build a report that will show me the most popular GROUP of option. SO, Table 1: CarID Color Engine etc.. 1111 Reg V6 2222 Green V6 3333 Blue V6 etc. ... ... Table2: CarID Option 1111 A 1111 B 1111 C 2222 A 2222 C 3333 B 3333 C So I want to build a query that will group my data like this: OptionCombo NBcars AB 10 AC 5 ABC 8 BC 12 etc. How the hell is this possible? note that option A and B must be the same that B and A!!! So mergin all option has text one on back of the other wont work. help on this please! [/QUOTE]