Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Lunch order system - Excel or Access?


  • Please log in to reply

#1
tiroshii

tiroshii

    Member

  • Member
  • PipPipPip
  • 423 posts
Trying to produce a basic system but not sure which program will do it best.

Basically what I want is a list of names and their balance (I guess this would be a number, say £5 if they are in hand, or a negative if they owe)

There would then be a field where you can enter how much money they have either paid in, or how much they have paid for their lunch.

A rough idea:

Posted Image

What I'm thinking is, this would not work in Excel as a sum would have to be used in the Balance field? Say =SUM C2-D2

However this would not allow the balance figure to be stored and the pay in and put fields blanked and changed daily.


It's hard to explain but I hope you understand. Any suggestions as to how I could do this would be greatly appreciated.

Edited by tiroshii, 16 July 2010 - 10:34 AM.

  • 0

Advertisements


#2
AstraNut

AstraNut

    Member

  • Member
  • PipPipPip
  • 384 posts
Have you tried using software like Mint? I'm sure Excel could be set up, but I don't remember anything about it now as quit using in years ago.

Quicken is good but does cost. I used it when it was just an "infant" and it kept track of whatever I wanted to set up.

Alternatives:

GnuCash (Free)
Personal Finance Software Review
  • 0

#3
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Using Excel is certainly possible. As ever, there are probably different ways to achieve the same thing.

One way would be to have a worksheet with the entries you have displayed then put a lookup on another worksheet to show the name, total paid in, total paid, and balance.
  • 0

#4
cubelunch

cubelunch

    New Member

  • Member
  • Pip
  • 1 posts
cubelunch.com perhaps?
http://cubelunch.com/
  • 0






Similar Topics

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP