Recent content by neuwirth

plog, that worked. I think jdraw's is the same thing, isn't it? Thanks to both of you!

OK, I tried to put together a Word doc with a picture and description of what I'm trying to do. I hope this makes it plainer, I'm not sure how to explain it.

OK, I tried the sub-query thing, and it still won't pull the records I want. Not sure if I did it right. Let me try to explain what I'm trying to do: I have one table with data concerning sales orders, including customer numbers and item numbers. In another table, I have those two fields...

I've attached a PNG file screenshot of the query. The error message I get is: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in...

I have a query in a pretty simple Access application for which I have posted the SQL code below. My issue is that when there is no value for the field CUSTNMBR in the table dbo_SOP60300, my query returns no results. I need for the query to return results for the other fields even if no value...

I am new here. I have to do some Access work for my job. I think most of what I do is probably pretty basic to experienced Access people, but I am befuddled by things like Left Inner Joins and such. I am posting a question today, along with the SQL code for the query that is not working the...