Help needed

[mariazetina]

I'm creating a data base for Employee Points and i Need help Subtracting Points from 2 Different tables

I have a points deduction Table where i enter points deducted and the date
and another table with starting points and current points. I need to be able to subtract from current points when i enter new infraction in the points deduction table. to Identify the employees I'm using their employee ID,


Thanks

[June7]

Use aggregate query to summarize data.

This is like an inventory tracking database (you inventory points). Use same concept. Review http://allenbrowne.com/AppInventory.html



Should give your threads more informative title than "Help Needed" - we know you need help but with what?