Richard, by working though Lesson3 in Expert 4 setting up the Query CustomerPictureQ to get a report with the customer Picture, uses the setup you describe in the lesson, using "CustomerT" and "CustomerExtendedT", setting the Join properties to "2" or "3" will run to an SQL Error and Access want me to run a it in a separateQuery first ... and than combine it.. what did I do wrong?
I don't understand the error you're getting. If you follow the video exactly, it should work. What's the SQL you end up with?
Ron FischerOP
@Reply 6 years ago
Richard this is the reply from system when I run the query "CustomerPictureQ" setting exactly akin Lesson 3 Expert4, link between CustomerT and CostomerExtendedT on option "2": SQL statement could not be executed because it contains ambiguous outer links. In order for one of the joins to be executed first, you need to create a separate abrege that executes the first join and then include this query in the SQL statement
Which order are the tables dragged into the view? Which one is on the left; which is one the right? When you drag the join and it gives you the option for the JOIN type what does it say? It might be that you are using the wrong join your for the fields on each side.
Ron FischerOP
@Reply 6 years ago
Well Richard, you are right, just started over build it from scratch according to the video and this time it worked as expected, thanks and sorry for the confusion I may have caused, :-))
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.
