Left Outter Join Confusion

[ShelleyCook]

I have one table with the majority of the information. This table holds the following:
SalesRep (lookup from another table)
Invoice Date
Date Paid
OE
Customer
NetSale
GP
Adj GP
Rate
Paid Amount
Paid in full?
Additional Notes
Commission Payout Date
Bonus Amount

I have a query that calculates the commission by multiplying the rate times the GP (gross profit). My supervisor wants this report to list all Sales Reps even if they did not sell anything. At this point, I have a box pop up and ask me for the date paid and the report is generated. I have tried doing a basic left join from my SalesRep table to the table I outlined above (joining to the 'salesrep' field. For some reason, the left join is not being enforced and the sales reps names are not appearing if they do not have any sales for the period. If anyone can help, that'd be great!!

[hype261]

Can you post the code for your sql query? That would help people to solve your problem.

[Stewart Ross]

The SQL would certainly help, as hype261 asked.

Even without the SQL posted, though, I'm certain you will find that you've negated your left join through the use of the pop-up which filters the data for the date paid. This is bound to exclude the sales reps who have no sales in that period, as they have no sales and therefore the dates, commission and so on are null in those cases. You could try changing the filter so that it is something like

<existing WHERE clause> OR [Commission Payout Date] IS NULL

-Stewart