For my check book

  • Thread starter Thread starter Wondering Why
  • Start date Start date
W

Wondering Why

Ok, I asked this in the excel group, but realized access would probably be a
better choice. I want to make a simple form that I can enter debits and
credits into and keep a running balance. The simpler the better, since I
will be the one using it and I am completely ignorant of how access works.
Is there one out there already made, so the wheel does not have to be
reinvented? I would greatly appreciate any and all help given.

Thank you

Steven
 
Why not stick with Excel? If you're familiar with Excel, it's pretty simple
to set up:
Here's one way:
Column A = Check number
Column B = Date
Column C = Description
Column D = Debit (check)
Column E = Credit (deposit)
Column F = Balance
Balance would be the prior balance + current credit - current debit

You could do the same in Access, but would need to run a report to get the
balance.

I'd sitck with Excel.
 
I agree with George, if a simple... one dimensional debit/credit "checkbook"
is all you really need.
However, since you posted the question on Excel and Access NGs, I'm assuming
you're unfamiliar with both.
Then... I would suggest purchasing or searching the web for a simple
checkbook/accounting program

hth
Al Camp
 
Contact me at my email address below if you would like me to build you a
simple checkbook database for a small fee.
 
Ok, I asked this in the excel group, but realized access would probably be a
better choice. I want to make a simple form that I can enter debits and
credits into and keep a running balance. The simpler the better, since I
will be the one using it and I am completely ignorant of how access works.
Is there one out there already made, so the wheel does not have to be
reinvented? I would greatly appreciate any and all help given.
Click to expand...

This has been invented over and over again. I'd really suggest
purchasing a checkbook program. Many exist, from the "league leaders"
Intuit's Quicken and Microsoft Money, to freeware or cheap shareware
programs. Excel would be easiest if you insist on doing it yourself,
as suggested elsethread; but you'll probably save more on overdraft
charges in six months than Quicken would cost! <g>

John W. Vinson[MVP]
 
Back
Top