database using MS access 2003. i wanted to track all the contract dates of a
certain employee. is that possible?
whenever the user would enter a new contract date for a certain employee, it
will not overwrite the previous contract dates, hence it would add up to the
list of the contract dates for that certain employee...
what could be the appropriate SQL statement or VBA command or function for that? i've tried to search for this function, but unfortuntely i wasn't able to find what i've been looking for. i would definitely appreciate all the help you guys can
give. thank you so much.
i tried to create a form and subform with this query
Expand|Select|Wrap|Line Numbers
- SELECT tblPosition.PositionName, tblContract.StartDateContract, tblContract.EndDateContract, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName FROM (tblOutlet INNER JOIN (tblDealer INNER JOIN (tblCompany INNER JOIN tblPosition ON tblCompany.CompanyIDPK = tblPosition.CompanyIDFK) ON tblDealer.DealerIDPK = tblPosition.DealerIDFK) ON tblOutlet.OutletIDPK = tblPosition.OutletIDFK) INNER JOIN tblContract ON tblPosition.PositionIDPK = tblContract.PositionIDFK WHERE (((tblContract.EmployeeIDFK)=[frmEmployee2].[EmployeeIDPK]));
but it won't work..
if you want to check the actual ms access file, here is the link:
http://www.gigafiles.co.uk/files/636/human%20resource%20info%20system_2006-10-11.zip
. the name of the form with the subform is frmEmployee2.
thanks a lot and sorry for the inconovenience...