Forum Discussion
Help with a change in Access design - price 3 for $50
How do you record payments now? It seems to me that the idea of charging skaters $17.00 a skate, with a $1.00 discount every third skate maintains things pretty well with a minimum of additional processing.
All you have to do is create an aggregate query that counts the number of times a skater has paid the $17.00 charge since the price increase went into effect and display the current status of their account accordingly. If it's the third weekly charge apply a discount (or maybe a refund of $1.00 into the table for that week) and collect the "balance" of $16.00.
It occurs to me that this is a variation on the punch card for coffee or donuts, etc. every time you buy a coffee, the shop punches a hole in the card. When there are 10 holes in the card, the coffee is free and you get a new card. Here, on the third digital "punch", you refund them $1.00 and only collect the remaining $16.00 balance.
The other path leads to complexity, chaos and lost sleep, IMO.
I'd like to take a whack at a possible design for that, in fact, if you can upload a copy of the accdb with just enough sample data (remove personally identifiable information) to get started.
Thanks.
How do you record payments now? It seems to me that the idea of charging skaters $17.00 a skate, with a $1.00 discount every third skate maintains things pretty well with a minimum of additional processing.
All you have to do is create an aggregate query that counts the number of times a skater has paid the $17.00 charge since the price increase went into effect and display the current status of their account accordingly. If it's the third weekly charge apply a discount (or maybe a refund of $1.00 into the table for that week) and collect the "balance" of $16.00.
It occurs to me that this is a variation on the punch card for coffee or donuts, etc. every time you buy a coffee, the shop punches a hole in the card. When there are 10 holes in the card, the coffee is free and you get a new card. Here, on the third digital "punch", you refund them $1.00 and only collect the remaining $16.00 balance.
The other path leads to complexity, chaos and lost sleep, IMO.
I'd like to take a whack at a possible design for that, in fact, if you can upload a copy of the accdb with just enough sample data (remove personally identifiable information) to get started.
Thanks.
