Capturing an employee in a team at a point in time

Hi, I would really appreciate some help on the following query:

I would like to design a db that captures employee data. At the moment
in the Employees table I have an entry for a team. However, it only
captures the "Current" team the employee belongs to. If the employee
changes teams then changing it in the current table will change it for
all previous entries and associated date.

The question is therefore, how would I go about to create a table (or
tables) whereby I can associate an employee a to a specific team at a
given point in time. For example if Employee1 was in team A for the
first half of the year and team B for the 2nd half of the year, then a
query associated with 01 Feb will return that the employee was in team
A but a query on 10 Oct will indicate the employee belonged to Team B.

Any help will be greatly appreciated. I am not sure what the apporach
I should be taking?

Thannks in advance.

.

Relevant Pages

  • RE: Sub report message
    ... performs the first join and then include that query in your SQL statement." ... Left join employee table to issue table. ... 1.I checked the main report query to see if there was a problem. ... All site staff are listed including all of the Food Service ...
    (microsoft.public.access.reports)
  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... use a text box to capture search criteria from the user. ... The After Update event is to ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Dave Hargis, Microsoft Access MVP ... use a text box to capture search criteria from the user. ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Initially, the form was unbound, but then I could not enter the ... use a text box to capture search criteria from the user. ...
    (microsoft.public.access.formscoding)
  • RE: How to code/perform a search
    ... When I read your response, about 50% of it makes sense to me. ... use a text box to capture search criteria from the user. ... record from the query. ... The form has objects for each column in the employee table. ...
    (microsoft.public.access.formscoding)
Loading