anthonyphillips
Registered User.
- Local time
- Today, 04:21
- Joined
- Nov 7, 2007
- Messages
- 50
Ok guys I have a quick question.
The Background
I have created a very simple database so that I can enter takings from the shop on a daily basis. i have put income and expenditure into the same table then created seperate forms for data entry.
The questions
I am looking for a way of auto summing AM takings and PM takings and output a value into the total takings box.
In turn i then want to take that value per day, sum it for the week, then have the total takings less total expenditure to give total profit or loss figures.
Is this possible.
thanks
Anthony
The Background
I have created a very simple database so that I can enter takings from the shop on a daily basis. i have put income and expenditure into the same table then created seperate forms for data entry.
The questions
I am looking for a way of auto summing AM takings and PM takings and output a value into the total takings box.
In turn i then want to take that value per day, sum it for the week, then have the total takings less total expenditure to give total profit or loss figures.
Is this possible.
thanks
Anthony