#Error in Query (nulls?)

Karl_Donaubauer 

Hi Karl, thank you for the response.  I thought for certain that would be the solution but unfortunately, I still get the =#error.  I confirm I do have nulls on [Invoice No] and [Reference].

the format is short text for both of those fields. 

let me know what is the next step.  thank you!

If it makes a difference, the query is as follows: (its a grouped query and a max on [WithdrawalDate])

SELECT tblPmtProposalALL.ID2, tblPmtProposalALL.DDNo, tblPmtProposalALL.Reference, tblPmtProposalALL.Amount, Max(tblDraws_CAWC.WithdrawalDate) AS MaxOfWithdrawalDate
FROM (tblDraws INNER JOIN (tblCompanies INNER JOIN tblPmtProposalALL ON tblCompanies.CoID = tblPmtProposalALL.ID2) ON tblDraws.ID = tblPmtProposalALL.DrawIDfk) INNER JOIN tblDraws_CAWC ON tblDraws.ID = tblDraws_CAWC.IDDraws
GROUP BY tblPmtProposalALL.ID2, tblPmtProposalALL.DDNo, tblPmtProposalALL.Reference, tblPmtProposalALL.Amount
ORDER BY tblPmtProposalALL.DDNo;