For my check book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wondering Why - 30 Dec 2004 23:30 GMT

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

Reply to this Message

George King - 31 Dec 2004 00:51 GMT

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.

> 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
[quoted text clipped - 6 lines]
>
> Steven

Reply to this Message

AlCamp - 31 Dec 2004 01:23 GMT

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

> 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
[quoted text clipped - 6 lines]
>
> Steven

Reply to this Message

PC Datasheet - 31 Dec 2004 02:13 GMT

Contact me at my email address below if you would like me to build you a
simple checkbook database for a small fee.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> 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
[quoted text clipped - 6 lines]
>
> Steven

Reply to this Message

John Vinson - 31 Dec 2004 02:56 GMT

>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.

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]

Reply to this Message