Multiple Query Results into one query

[Sarma]

(1) I have a table of 11 cricket players - A, B, C, D, E, F, G, H, I, J, K.
(2) I have a query that indicates batting strengths of 10 of them. The strength of 11th player, K, is not there because it is 0.
(3) I have bowling strengths of 4 of them in a different query (say D,E,F,G). The bowling strengths of the remaining players is 0.
(4) I have a query that indicates the fielding strengths of 8 of them (say D, E, F, G, H, I, J, K).
(5) Now, I want to frame a table that indicates all the 11 players, their batting strengths, their bowling strengths and their fielding strengths. When I form a query I am getting a list that comprises of players who are common to all the tables (D,E,F,G). But I need the data of all players into one tabular form of all 11 players.
(6) I am not very conversant with MS Access. I came this far by making tables and forming queries. I am converse upto this.
Please help.

 

[Thomko]

Sarma, you need outer joins.

In the query builder, double click the line that links your tables (the join). A dialog should pop up, that has three options. The default is the inner join (Option 1). Select the option that is called "Contains ALL records from Players table ..." and OK out. Now the line has an arrowhead at one end indicating an outer join.

There should be plenty of information about outer (left) joins on the internet, if you need further reading (Of course you can also post here)

HTH
Thomas

 

[Sarma]

Thanks, Thomas. It has worked.

But now I have different type of problem and I need your help again.

I have a query in which marks attained by various students are given in the following format:

Student Name Exam1 Exam2 Exam 3
1
2
3
4, etc..

I need to add the marks for each student as a different query.

The problem is that some of the students have not taken one of the exams and the cell is a null set. But still I need to do it.

Please help me again.

Rgds.

Sarma

 

[wilpeter]

Sarma: Assuming you mean you have a single table with StudentName, Exam1, Exam2, etc., then the query would include all those fields and a Calculated field:
TotalExams: Nz([Exam1],0)+Nz([Exam2],0)+Nz([Exam3],0)
keep adding for each field to be included.
Nz(field,0) stands for convert the field to 0 if Null.