Search results

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...