The full error message is - Runtime error 3075
Invalid use of '.','!', or '0', in query expression 'Forms.TrustReconAll BranchesFrm.[AcctNameFld'.
Below is the code
I have checked the code a 100s times and still cant see where my problem is.
I need new eyes and an open mind
Invalid use of '.','!', or '0', in query expression 'Forms.TrustReconAll BranchesFrm.[AcctNameFld'.
Below is the code
Code:
INSERT INTO TrustReconRptTemp ( BranchName, AcctName, BSBandAccountNo, DayEnded, LedgerAmount, UnprocessedDeposits, UnprocessedWithdrawals, UnpresentedCheques, UnpresentedDeposits, ExpectedLedgerAmount, BankStatementAmount, Discrepancy, Adjustments, AdjustedTrustLedgerAmount, CompletedBy, CompletedDate )
VALUES (Forms.TrustReconAllBranchesFrm.[BranchNameFld], Forms.TrustReconAllBranchesFrm. [AcctNameFld], Forms.TrustReconAllBranchesFrm.[BSBandAccountNoFld], Forms.TrustReconAllBranchesFrm.[DayEndedFld], Forms.TrustReconAllBranchesFrm.[LedgerAmountFld], Forms.TrustReconAllBranchesFrm.[UnprocessedDepositsFld], Forms.TrustReconAllBranchesFrm.[UnprocessedWithdrawalsFld], Forms.TrustReconAllBranchesFrm.[UnpresentedChequesFld], Forms.TrustReconAllBranchesFrm.[UnpresentedDepositsFld], Forms.TrustReconAllBranchesFrm.[ExpectedLedgerAmountFld], Forms.TrustReconAllBranchesFrm.[BankStatementAmountFld], Forms.TrustReconAllBranchesFrm.[DiscrepancyFld], Forms.TrustReconAllBranchesFrm.[AdjustmentsFld], Forms.TrustReconAllBranchesFrm.[AdjustedTrustLedgerAmountFld], Forms.TrustReconAllBranchesFrm.[CompletedByFld], Forms.TrustReconAllBranchesFrm.[CompletedDateFld]);
I have checked the code a 100s times and still cant see where my problem is.
I need new eyes and an open mind