A
Alexandre Saillant
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!
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!