Recent content by JerryWoodstock

Basically after re thinking my post and to make a long story short what i ned to do is take two tables within one database and use the unique field to relate them together then compare every field in a specific record to make sure that all data is identical.If it isnt i then need to output...

I'm having a hard to describing this as i have attemted to write this post a few times now. Basicaly whats going on is as follows. We currently have a in office database that is modified from day to day to keep up with the current going on's of the office .We also have an organization...

Hehe sorry i must seem as dumb as a post . im hoping i have this down pat. So what your saying is that when a person leaves a position instead of imediatly deleting that record i would first copy the info to basically a duplicate table and then delete it from the current table. Again im...

Thanks for answering back again Wayne This is more appreciated then you could ever imagine. This is for a Department in Goverment. the Department is seperated into roughly 10 different sub sections eachsub section has its own positions and the position names are based on the subsection name and...

How should i set this up then ? sorry for all the questions but i really want to get this right. I will be needing to Query the info onto reports. Should i redo me ERD ? i currently have a member position and accomidation table(s). where the position and accomidation are related to the...

I was worried that if i kept this info in side the database that it would increase the size by to much is this the case? Im in an Organization that re orgs quite a bit changing position names and such involving deleteing positions and entering new ones i was worreid that if I put it in a table...

where i work we have a personel database where we collect information of employees . Currently when a user leaves he is deleted from the database. The problem is that we need this info for roughly a period of two years.What is the best way to handle this situation? what is the best method...