Check Register Help

[gearhead03]

I am adding a simple check register to a billing database I set up. My question is, would it be best to set the table up with a separate debit and credit fields or with an "amount" field and then have a field that you can select debit or credit.


Mark A. Kale

 

[MichaelRed]

... check register ... " seems to imply single field with SIGNED value. otherwise you need to do extra work for the balance.







MichaelRed

 

[gearhead03]

That will work, however most (if not all) of the values will be enter via a form that "looks" like a check. From this form Checks will be printed. All checks are written with positive numbers. For the "register" form I was considering a format similar to Quickens (and most hand written registers) that have separate columns for credits and debits. My original question stems from that. Do you think their table is setup like that register or are they just using some creative froms making. I can work with either format the table is in. I just was not sure which would end up being easier in the long run. BTW it's been so long since I actually USED a paper register I had to find one o study how it looks!!

Mark A. Kale

 

[MichaelRed]

I'd use the single field, noting difference between deposits and withdrawals by the sing, as it seems more intuitive. At any point, the correct balance is fond with a simple aggregate. The only reason I would see for the two field approach would be an aid to the handicapped who might not rember to enter / use the sign in their calcs.

Of course the entire (entry) process is specifically for the user's benefit, so I would consult them or even possible offer a variety of forms and let them choose. After all, the real issue is to maintain the balance according to the data, ans possibly shopw various segments / perspectives.

In almost any useful (cheek register) application, the user would also want to be able to identify categories of both income and expenses and total them over periods, e.g. where did it come from & where did it go.




MichaelRed