A complex problem (well I think soanyway) involving date sensitive variables
I need to collect information on16 or so events of 9 different types. Each event type has a value associated with its duration ('points' as integer in my code) but its the running totals that are a problem.
For each of the 9 types of event there are a different set of rules governing how the totals are allocated depending on dates. These are
Type1 1 point per hour of event, no daily or yearly limits
Type2 1 point per hour of event, 5 max per day, no yearly limit
Type2a As above but need to be distinguishable from Type2
Type3 5 points per event, max 10 per year
Type3a As above but need to be distinguishable from Type3
Type4 Variable points per event, max 10 per year
Type5 1 point per hour of event, no day limit, max 10 per year
Type6 1 point per hour of event, 5 points per day, 10 points per year
Type7 Variable per event, max 50 points per event, no date/time limits
I have designed and written the code for the GUI and also the code to successfully generate the points per event (ie I can generate the points without problem providing I don't have to apply any of the above rules). I intend to store information relating to each event in a database (using data controls) for later printing out a summary, which I think I can do although I haven't actually done it yet. What I cannot do at all is conceptualize how I approach the problem of the keeping the running totals so that all the Type rules are applied correctly and in such a way that I can manipulate them for report purposes at a later stage. Despite much bleeding from the ears and furrowing of the brow I'm no further and I have been at this for weeks now.
All help very, very gratefully received!!
Neill (Newbie in case it wasn't obvious!)