Excel Genius - Access Idiot
Recently finished a 14 hour training on Access, so now I know enough to really be annoying. (thanks for your help)
I had been keeping a check ledger in excel and am now moving it to access and my basic question is should I have one "transactions" table
or two separate tables one for "Deposits" and another for "Payments/withdrawals".
Big picture information
this is for a non profit and I have 15 chapters that will make regular dues payments into this account. sometimes they are fined and thus will make different payments for fines.
also sometimes a chapter will have problems and this account will make loans to those chapters and then they will pay that back over a period of time.