Hi everybody, I need an ASP/Access tool which will help me to get my monthly coffee bill done quickly. My colleagues at work drink coffee and check a box on a list for every coffee they drink. Sometimes they buy coffee, milk or sugar. I have to count all their coffees and substract the milk or sugar they bought. Then I have to run around and collect the money. What I would like to have is: - the possibility to add/remove/hide users from the list of current coffee drinkers (new colleagues/retired c./c. in holiday) - to put in the number of cappuccino and the number of espresso every single colleague drank - to put in the amount of money every single colleague spent on milk and so on (might be 0 as well if he spent nothing) - the possibility to have different prices for cap. and esp.: - for the neighbour dept., a cap. is x?'? and the esp. is y?'? - for our dept., there is a formula: the total amount of money spent on _coffee_ DIVIDED BY [number of esp. drunk PLUS number of cap. drunk] EQUALS TO price for esp. (esp.=total coffee/(esp.+cap.) the total amount of money spent on _milk_ DIVIDED BY the number of cap. drunk EQUALS TO price for milk (milk=total milk/cap.) - the money the coll. have to pay is: (my dept.): the money they spent on milk PLUS the money they spent for coffee MINUS the amount of money for cap. and esp. they drank bill=(milk+coffee)-money for esp. and cap. (this might be a negative value which means, I will get the money, otherwise I will have to pay them out). (the other dept.): amount of cap. * y?'? + amount of esp. * x?'? - I need the number of esp. and cap. summed up for controlling (there is a counter in the machine) so that I can see how many times coffee was drunk without checking the box. - I need everything stored in an Access DB for later viewing. - I want to send emails to my colleagues with their bills. - no must: print an empty list with the names and the days of the month to check boxes
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
ASP (no ASP.net) for Windows 2000 Server with Access DB (no SQL Server)