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 <joegkushner@
>
> 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]
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Nenhum comentário:
Postar um comentário