Expand|Select|Wrap|Line Numbers
- SELECT tblBank.BankID, Now() AS TimeRecd, Val(Right(nz([SerialID],0),3)) AS ConsID, "AutoCASH" AS RecUser, tblBank.Dt, Forms!frmRecCASHRunningBal!tbGroup AS GroupID
- FROM tblBank
- WHERE (((tblBank.Dt)>([Forms]![frmRecCASHRunningBal]![tbBankMinDate]-1) And (tblBank.Dt)<([Forms]![frmRecCASHRunningBal]![tbBankRecDate]+1)));
2. tbBankMinDate -1 = 01/07/08
3. tbBankRecDate + 1 = 03/07/08
4. Both tbBankMinDate and tbBankRecDate are formated to be date
5. A very similar query is running properly where the date is filtered exaclty the same way only using different text boxes.
6. The above query was working fine a few days ago.
Thanks in advance