Hi Access VBA Gurus,
I am a beginner to Access 2002, let alone Access VBA. I have a quick question. Attached is a database of just a single, sample 'Month-End Outstanding Accounts' table. There are 3 customer ID's, and each month I need to INSERT end-of-month balances into this table at the respective, logical slots (provided end-of-month balances for a given customer are positive).
Assume CustomerID 2 has a balance of $150,000.95 as at 30/06/2006, while CustomerID 1 and 3 each have zero balances as at this same date. I will thus need to insert just a balance of 150000.95 as a new record for CustomerID 2, with Date field entry as 30/06/2006, as record number 10 of 12 in the attached 'AcctRcvLog' table.
How do I do this? Note that each month-end 'source data' is contained in an Excel spreadsheet with a 3-column structure similar to the attached 'AcctRcvLog' table. So, the Excel source file dated 30Jun06 will have just a 2-row table, with first row being a header row with entries [CustomerID, Date, Amount O/S], and second row being [2, 30/06/2006, $150,000.95]. Please note that as balances for CustomerID 1 and 3 as at 30/06/2006 are zero each, these do not appear in the Excel source data file.
If anyone could advise, this humble Access VBA newbie would be eternally grateful.
Thanks a million in advance.