ambiguous outer joins

R

renwick

My database for was not recording in the right place,
realised it was not bound to the right sourse so fixed it,
not it won't run because my SQRL has ambiguoise outer
jons, it needs to know which to perform first. I don't
know which joins it is talking about and also how to
create a new quiery that will tell it or how to include
that in te SQRL in the quiery that the form runns off.
Here is the SQRL for the qurie as it stands.

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led].[2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led].[A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led].[A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual].[A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual].[A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work].[5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work].[2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work].[4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work].[A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
 
J

Jeff Boyce

From the long list of what appears to be "repeating fields" in your SQL
statement, I wonder if your data structure isn't causing you (and Access)
some issues. Queries are only as effective as the underlying data structure
they rely on.

Perhaps you could provide a bit more description of your data structure...

--
More info, please ...

Jeff Boyce
<Access MVP>

renwick said:
My database for was not recording in the right place,
realised it was not bound to the right sourse so fixed it,
not it won't run because my SQRL has ambiguoise outer
jons, it needs to know which to perform first. I don't
know which joins it is talking about and also how to
create a new quiery that will tell it or how to include
that in te SQRL in the quiery that the form runns off.
Here is the SQRL for the qurie as it stands.

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led].[2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led].[A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led].[A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual].[A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual].[A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work].[5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work].[2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work].[4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work].[A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
Click to expand...
 
R

Renwick

The database is to collect complex data on observations of
school children. Each catagory is observed for 10min the
way that the raw data is provided for data entry is in
sheets of 5 min each, so we obsereve for exapmle teacher
led, how well they pay attention for 5 min and then move
onto another sheet I have to keep the entry system under
the same rules as the paper versions. each behaviour is
either present or not, we then observe attention for when
they are working individually for 10 min and then in a
group of their peers for 10 min. That is why there seem to
be repeating catagories. so 1A is sheet one and A1A is
sheet two, there will be the same name present for the
three types of classroom activity. all that I want o do is
display it in a form but the form runs off this quiery
becaue there was too much data for all three data types
and both sheets to be on one table, so I have had to split
it up. THey data is meant to be locked together using the
ID number which the computer genertates. This is to ensure
data protection so that only we know that childs name. THe
ID number joins seem to behat is causeing the problems as
each type of classroom behaviour has an ID number present
on the Quiery in order to ensure we see the teacher led,
group and individual work for the same ID number on each
record. I know that its complicted, I couldn't make it
work any other way, believe me, I tried!

Renwick
-----Original Message-----
From the long list of what appears to be "repeating fields" in your SQL
statement, I wonder if your data structure isn't causing you (and Access)
some issues. Queries are only as effective as the underlying data structure
they rely on.

Perhaps you could provide a bit more description of your data structure...

--
More info, please ...

Jeff Boyce
<Access MVP>

renwick said:
My database for was not recording in the right place,
realised it was not bound to the right sourse so fixed it,
not it won't run because my SQRL has ambiguoise outer
jons, it needs to know which to perform first. I don't
know which joins it is talking about and also how to
create a new quiery that will tell it or how to include
that in te SQRL in the quiery that the form runns off.
Here is the SQRL for the qurie as it stands.

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led]. [2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led]. [A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led]. [A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual]. [A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual]. [A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work]. [5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work]. [2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work]. [4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work]. [A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
Click to expand...

.
Click to expand...
 
R

Roger Carlson

Occasionally, a situation arises in a multiple table query in which you need
to use an Outer-Join. Oddly, sometimes Access allows you to do it, and
sometimes it gives you the very unhelpful "Ambiguous Outer Join" error.



Why? Well, to understand this and how to correct it, let's first determine
what an Ambiguous Outer Join is.



When Access processes a multiple table query, it needs to determine the
order in which joins should be made. Should it join Table1 to Table2 first
and then join Table3? Or should it do it in some other order. This is part
of the Rushmore technology of the Jet

engine. It tries to determine the most efficient way to process the query.



In the case of standard Equi-Joins, the query result will not vary based on
the order that they are joined. However, this is not the case with
Outer-Joins. There are times, when using an Outer-Join, that the result of
the query will be different depending on the order in which joins are
created. Access cannot now determine the order to join the tables. This is
an Ambiguous Outer Join.



Another way to explain it, is in terms of what you see in the QBE grid. A
table which participates in an Outer join and the arrow is pointing
*towards* it cannot participate in either an Inner Join, or another Outer
Join where the arrow points towards it.



Graphically:

These are illegal:

1) Table1 -----> Table2 ----- Table3

2) Table1 -----> Table2 <---- Table3



This is legal:

3) Table1 -----> Table2 ----> Table3



In order to solve this, you are going to have to split the query into a
stacked query, just like Access suggests you should in the error message.
So you create a query joining the first two tables and, in a second query,
join the first query to the third table.



Thus:

1) Query1:

Table1 -----> Table2



2) Query2:

Query1 ------ Table3




--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


renwick said:
My database for was not recording in the right place,
realised it was not bound to the right sourse so fixed it,
not it won't run because my SQRL has ambiguoise outer
jons, it needs to know which to perform first. I don't
know which joins it is talking about and also how to
create a new quiery that will tell it or how to include
that in te SQRL in the quiery that the form runns off.
Here is the SQRL for the qurie as it stands.

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led].[2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led].[A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led].[A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual].[A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual].[A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work].[5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work].[2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work].[4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work].[A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ambiguous outer joins 1
Automatic Cut & Paste - Possible? 1
Page numbering with Merged Document and IF statements 1
Lookup Formula 3
Paste special into a filtered work sheet 0
Conditional formatting 3
formulas for conditional formatting 5
Programming cells to read other cells 1

Top