The SQL looks good to me.
Only thing I can suggest is to start by removing all criteria and executing the query.
If records are returned, change the WHERE clause to
Code:
WHERE DateSerial(Left([ORECDT],4),1,1)+Mid([ORECDT],5,3)-1)>#3/1/2016#
and execute the query.
If records are returned, then add the 2nd criteria
Code:
WHERE DateSerial(Left([ORECDT],4),1,1)+Mid([ORECDT],5,3)-1)>#3/1/2016# AND IESFILE_BILLING.BIAMT=[ORBAML]
This is to determine which of the criteria is causing the problem.
BTW, you have a field name "ORODR#".
Shouldn't use special characters in object names. And the hash mark (#) is a date delimiter.