Extrat data in Table A from Table B

[isaacwel01]

Please to help me for the problem of access.

there are two table, One is history (Table A), One is match (Table B).

Table A include all data. Table B is a list used to search information.

Table B, There are

Company 1 Compnay 2
1 A E
2 B C
3 F A

Company A and Company B is a pair of data want to search.


Table B there are many history data

Only use a set one to example now, i Would like to search the times appear

A E
E A
A E
A E
total 4 times

B C
C B
total 2 times



and result want to


Company 1 Compnay 2 Times
1 A E 4
2 B C 2
3 F A 3

Also can set the cut off date, for exmaple Since 2014 to now.


Thank you very much, and my english is very bad. sorry for that.

The access file is in http://www.2shared.com/file/XIgMoC8c/example.html .
Thank you very much

 

[isaacwel01]

a bit wong sorry. Again The Question


Please to help me for the problem of access.

there are two table, One is history (Table A), One is match (Table B).

Table A include all data. Table B is a list used to search information.

Table B, There are

Company 1 Compnay 2
1 A E
2 B C
3 F A

Company A and Company B is a pair of data want to search.



Table B there are many history data

Only use a set one to example now, i Would like to search the times appear

Company 1 Company 2 Business Project
A E 1 0
E A 0 1
A E 0 1
A E 0 1
total 1 3

B C 1 0
C B 1 0
Total 2 0

and result want to


Company 1 Compnay 2 Business Project Business % Project %
1 A E 1 3 25.00% 75.00%
2 B C 2 0 100.00 % 0.00%



Also can set the cut off date, for exmaple Since 2014 to now.


Thank you very much, and my english is very bad. sorry for that.

The access file is in http://www.2shared.com/file/XIgMoC8c/example.html .
Thank you very much

 

[Joe4]

Cross-posted: Extrat data in Table A from Table B

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).