Hi
I download loan balances (Acct #, Amounts and Dates) each day into an Access table. I then run an append query that adds each account balance to a cumulative table so that I have a running history of balances each day.
What I need to do now is just extract month end balances from the trended table. Excel has an EOMonth function that calcs end of month. IS there anything equivilent in Access or with code that will allow me to do this? Thanks.
JDTTEK
I download loan balances (Acct #, Amounts and Dates) each day into an Access table. I then run an append query that adds each account balance to a cumulative table so that I have a running history of balances each day.
What I need to do now is just extract month end balances from the trended table. Excel has an EOMonth function that calcs end of month. IS there anything equivilent in Access or with code that will allow me to do this? Thanks.
JDTTEK