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
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.
ASP (no ASP.net) for Windows 2000 Server with Access DB (no SQL Server)