Well this kind of depends on the structure of the database but in a relational format it would be best to set up a table (it its not there already) that defines the disciplinary actions (for example: uniquekey, value, description) this way if in the future the description should change or new ones added or old ones removed updating won't a coders nightmare. Then query this table ascending, then when generating the report using VBA code begin total the individuals points when he hits a threshold then add the uniquekey as a row to their disciplinary actions table. This table would hole disciplicinary actions and their status. This allows for future flexibility and if done properly will aid in migrating it to a SQL database if the need should arise later on.
--- On Thu, 5/28/09, joegkushner <[email protected]> wrote: > > I can see making a form that they fill out to see if action has been taken on > the > current sum of points but am blanking on how to show the multiple levels. > > For example, at 10 points, users get a verbal warning and at 16 they get a > written. > It's easy to figure the sum and show "written warning" but I'm spacing on how >to show > that they should get a verbal at 10 and a written at 16. > > Any help? > [Non-text portions of this message have been removed]
