To record Employee transfer date OR to record employee title? (1 Viewer)

[degremont]

Table1 - Employee
... EmployeeID Name Title ...
... 1 ZZ engineer ...
... 2 LL engineer ...

Table2 - Site
... EmployeeID Location Date ...
... 1 BJ xxxx ...
... 1 TJ xxxx ...
... 2 BJ xxxx ...
... 2 SH xxxx ...

Query1 - Employee & Site
Location Title Count
BJ Engineer 2
TJ Engineer 1
SH Engineer 1

When employee change position, employee title changed. For example, ZZ upgrade to Manager. The Query1 can not show "BJ Engineer" as Count 2.

Solution1:
To record title in Table2, Query1 is only about Table2 - Site.
Solution2:
To record transfer date somewhere, and cheange Query as needed.

Which of the above solution is better?

 

[Uncle Gizmo]

I don't understand your question could you rephrase it please.

 

[degremont]

Table2 record the relation between Employee and Site. One Employee could have many different days in one site, and I want to caculate the total days for each title. The problem is if employee change title, the caculation should keep the past record with old title and new record with new title.
I was thinking about the 2 solutions, but I don't know which one is better. Or there is another good solution...