Re: Need help with accounting database

My approach:
Have two table. One with your client's name, addy, and so on. No
balances needed here at this point.

The other with

TransID -- Auto Increment
Customer ID -- Same as you noted above
Trans Date -- Date of the Transaction

MonthEnd -- The month end of the transaction occured.
DateSerial(Year(Trans Date),Month(Trans Date)+1,1) which can be updated
with a query on a form closed.

TransactionType - Pmt, Service Charges, Interest, etc.

Amount - Payments should be negative. Service charge, and interest
should be positive.


On a report create you can use create a calculation Beg Bal.
dsum("[Amount]","tblTransaction","CustID = " & chr$(34) & [CustID] &
chr$(34) & "[MonthEnd] < " & [MonthSelected] &))

The ending bal Calulation is dsum("[Amount]","tblTransaction","CustID =
" & chr$(34) & [CustID] & chr$(34) & "[MonthEnd] <= " &
[MonthSelected] &))


Notice I have ditched the prev and currentBalDue fields in any table.

This is not exactly correct, but should give you ideas on how to
proceed.

.

Relevant Pages

  • Re: Find personnelIDs previous record based on date
    ... (SELECT Max(q.[Date of transaction]) ... Table: Prev ... and you only want to see previous "promotion" ... I need to show where the agent was promoted from, (department, ...
    (microsoft.public.access.modulesdaovba)
  • Re: UpdateBatch - taking a while
    ... the ado recordset to see how many "changed" records are there and force an ... If done inside a transaction, ... the opportunity to rollback the whole set .. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Unauthorised Overdraft Charges
    ... In message, Peter Saxton writes ... You do A and we will waive all our transaction and service charges for ... your account. ...
    (uk.finance)
  • program is end, but the page seems still be running?
    ... it imports one file, and does some ... operations for each row, in each row, it uses transaction, if there are ... Does anyone know how to resolve this problem? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Slidell LA
    ... >> Wouldn't it be horrible to have been in the middle of a transaction when ... We watched what happened with Larissa. ... Carey in MA ... Prev by Date: ...
    (rec.crafts.textiles.quilting)