Thanks Lynn. Using your code, now I get this:

Msg 4145, Level 15, State 1, Line 24

An expression of non-boolean type specified in a context where a condition is expected,...

Here is my query:

SELECT dbo.RHeads.Branch, dbo.RLines.Part, dbo.Stock.Free AS [On Hand], dbo.RLines.CQty AS [Qty Last Received],

dbo.RHeads.DateTime AS Date,

...