Hi All,
I have a BAQ for PR check analysis to throw out deduction info that can be used for reporting purposed.
I have successfully related the PRChkDtl table to the PRChkDed table and the EmpMas tables.
I can set a criteria for the recordset to PRCHECKDTL.CheckDate = (IsConst) 04/16/2007 (DateConstant) and all of the correct records are returned.
However, we need to be able to have all of the values returned for the entire period of time between actual pay periods.
Therefore, in my BAQ I had it set up to read
CHKDTL.CheckDate >=4/16/2007
(new line) AND CHKDTL.CheckDate < 4/30/2007
It is at this point when the BAQ syntax analysis fails and I get a message saying:
** Unable to understand after -- ".CheckDate =". (247)
Does anyone have any idea why I can not use the range?
Thanks
Carey
_________________________________________________________________
Make every IM count. Download Windows Live Messenger and join the i�m Initiative now. It�s free.��
http://im.live.com/messenger/im/home/?source=TAGWL_June07
[Non-text portions of this message have been removed]
I have a BAQ for PR check analysis to throw out deduction info that can be used for reporting purposed.
I have successfully related the PRChkDtl table to the PRChkDed table and the EmpMas tables.
I can set a criteria for the recordset to PRCHECKDTL.CheckDate = (IsConst) 04/16/2007 (DateConstant) and all of the correct records are returned.
However, we need to be able to have all of the values returned for the entire period of time between actual pay periods.
Therefore, in my BAQ I had it set up to read
CHKDTL.CheckDate >=4/16/2007
(new line) AND CHKDTL.CheckDate < 4/30/2007
It is at this point when the BAQ syntax analysis fails and I get a message saying:
** Unable to understand after -- ".CheckDate =". (247)
Does anyone have any idea why I can not use the range?
Thanks
Carey
_________________________________________________________________
Make every IM count. Download Windows Live Messenger and join the i�m Initiative now. It�s free.��
http://im.live.com/messenger/im/home/?source=TAGWL_June07
[Non-text portions of this message have been removed]