Recent content by tanha

Thanks for the post man...................................................................................

Hi. if anyone has the MS Access database which includes the Employee, Project, Department, Works_on, Dependent tables, plz post here... Thanks.

Thanks very much...

Hi everybody, I created a Tracking Database in Ms Access, and then My supervisor asked me to make the report too, means as the following format of attachment, how it is possible to be done in Ms Access? See the attachment...

No, Just I want to know, if Use like I mentioned before, then what is the difference...I want to know more...

Thanks for the code... If I dont provide selfjoin, and just add a field Named "Supervisor" which keep the staff code, and then use the following query SELECT * FROM tblPersonnel WHERE Supervisor = 'Criteria'; then what is the difference???

Look I did as you mentioned, and link u posted, but: 1. is it possible to enter the last supervisor which does not have supervisor here 2. Then in this format, we should enter first all the sub-staff, then sub-staff supervisor, ...and at last the big-supervisor, because I want the supervisor...

Thanks for replying, Then How can I provide relationship, I mean many staff may have one supervisor, and that supervisor and maybe another supervisor again has one supervisor... May I request you be in detail plz?

Hi again everybody, I could not arrange and make the tables, so I attached everything...any help ang guide would be appreciated. Thanks

Thnx again

thnx for quick replying, may I request you just attach a sample?

Hi, I want to create a database for the staff of a company, the attributes of the staff are (Code, FirstName, LastName, ContactNo, DateOfBirth, Position, Department and so on), now many staff has one SuperVisor, and that SuperVisor, maybe other SuperVisors has a SuperVisor, and again that...

Thanks a bunch UMH, It works perfect...

Sorry for posting again, Anyone here guide and help me through this...Specailly Mr. UMH

Mr. UMH, May I request you kindly post the solution plz...Because I am really in need of that...