Jwrnana wrote:
I pasted your SQL query in place of mine. It would not run because of
error - "improper bracketing of John Deere Invoice".


OK.
Probably not an accurate transcription of the error, but there are 2
reasons why what I sent might not work:
a) line breaks inserted in the forum message
b) I didn't spot some instances of fields defined in the output list
being used in other output fields, e.g. [JD Invoice Amount]

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup