Hi All,
Firstoff, sorry if I sound like an extreme beginner, I have had experience grabbing stuff from access and sql database, but never building one..
If someone can help with just something general or even a link to a place on the web that would be helpful, here is what I want to build...
I worked at an office years ago, where we utilized Access, and whenver I opened it the report (?) it asked me for information such as: Date, Number of Tickets, etc. and then created a report based on that.
What I want to do, is to create something similar, but to make it a bit more complex in that the database would be able to do calculations, as an easy way to manage my expenses.....
Just something like: Date, Cash Spent today, Cash deposited in bank account, Checks received today, Checks written today. And then maybe a report being displayed stating: Cash to deposit or something to that effect.
Is it possible to do the above? Also, is it possible for the calculation to look at all the records in the entire table to keep a running history so that I easily do this?
Please let me know if I am not being clear. I am trying to do this for a small business I have, and hoping that I can make this user friendly enough so that even someone who doesnt know much about computers can simply open Access, punch how much they spent, how much they deposited and get a result.
Thanks, any help would be appreciated.