Which office program do I use

[barrytoo]

This will probably seem silly to most of you, I am an old dbase 3 user trained in the military and excell has me all confused.
Situation: I run a small carnival vending booth. I sell nine flavors of snow cone, 6 varieties of pop and various other items. My cash register allows the input of plus and prints them to the journal tape each item is assigned a differnt plu. I thought I would be able to open excell and by using a combination of GET statement and If then statements I would be able to input the numbers from the journal tape followed by a return and route the information to a corresponding report. In Example I would be able to type in 1 and hit return 2 hit return 1 again hit return and when I was finished with the input be able to have a report that said 2 grape snow cones 1 cherry snow cone. I have not been able to find a get statement in the formula listings am I not using the corrct program would acsess be a better choice? Any advise on how to accomplish this would be greatly appreciated.

 

[VirtualTrainer]

If you want to input data and generate a report from it, then you should probably use Access. Excel is a spreadsheet application normally best used to analyze and keep track of small amounts of data, and Access is a database application best used when you need to generate reports from data and keep track of data that is subject to frequent changes.

Karyn



Karyn's Toolkit
Free Microsoft Office Tutorials

http://tutorials.esmartweb.com