Fields

[channell]

Ok, I have a question... I have my employees, and I have an area in the
building in which they are mainly assigned. Now, sometimes they move around
to cover for employees who call in sick or whatever the reason might be, and
I have to change their posistion or the area in which they work.

Each day they have a record with the [Workdate], a [Position] and some other
information. For all my 50 employees, I have to go in each record each day
and put where they worked [Position].

Is there a way I can have the [Position] field in my Employee Table and act
like a date field? Meaning: I want the [Position] Field to be what it was
for that day, and I want my reports to display that.

IE:

"John Smith" worked in "Section A" on 1/13/09.
"John Smith" worked in "Section J" on 1/14/09.
"John Smith" worked in "Section A" on 1/15/09.

I don't want to have to input that field every day like I am doing right
now. I want it to be defaulted per employee, but changeable in the event
that they move to a different [Position] one day once in a while. I hope
this makes sense.

Thanks

 

[Wayne-I-M]

There are lots of ways to do this.

One simple method would be create
table 1 = employees
table 2 = possitions
tables 3 = DaliyPossitions

table 3 =
DialyPossitionID
employeesID
possitionID
Date
This assumes that each person will not move within the date ??

Next create a continous form based on an updateable query
Set the default possitions for each employee

On Open = message box - do you want to update any employees today ?

If yes - change the emplyees possition
then save

If no - save

Note the daily possiition will be stored as linked record in table 3
This will take a little work to get it to do what you want but not that much.

Good luck

 

[TedMi]

I recommend the following tables:

tblEmployee
EmpID Autonumber PK
FirstName
LastName
Other employee info (address, telnum, hire date, etc.)

tblSection
SecID PK
SecDescription

tblEmpSec - holds the assignment of employees to their "normal" sections
EmpID FK to tblEmployee
StartDate (date when employee was assigned to a section)
Compound PK on EmpId, StartDate to ensure employee assigned
to only one section at a time.
SecID FK to tblSection

tblDailyRecord
EmpID FK to tblEmployee
SecID FK to tblSection
WorkDay (date)

Each workday, a record can be automatically created in tblDailyRecord for
each employee, with his "normal" section. That table can then be edited to
reflect any reassignments, or to indicate absences. Thus, the entry of work
in normal sections is automated, and only exceptions need be processed by
hand.

Good luck!
-TedMi

 

[channell]

Thank you thank you! I am working on it right now, so I may need some more
help to get this thing going, but I was curious about one thing. I will
tinker with it, but what do you mean by "...Compound PK on EmpId, StartDate
to ensure employee assigned to only one section at a time."? Thanks!

I recommend the following tables:

tblEmployee
EmpID Autonumber PK
FirstName
LastName
Other employee info (address, telnum, hire date, etc.)

tblSection
SecID PK
SecDescription

tblEmpSec - holds the assignment of employees to their "normal" sections
EmpID FK to tblEmployee
StartDate (date when employee was assigned to a section)
Compound PK on EmpId, StartDate to ensure employee assigned
to only one section at a time.
SecID FK to tblSection

tblDailyRecord
EmpID FK to tblEmployee
SecID FK to tblSection
WorkDay (date)

Each workday, a record can be automatically created in tblDailyRecord for
each employee, with his "normal" section. That table can then be edited to
reflect any reassignments, or to indicate absences. Thus, the entry of work
in normal sections is automated, and only exceptions need be processed by
hand.

Good luck!
-TedMi

Ok, I have a question... I have my employees, and I have an area in the
building in which they are mainly assigned. Now, sometimes they move
around
to cover for employees who call in sick or whatever the reason might be,
and
I have to change their posistion or the area in which they work.

Each day they have a record with the [Workdate], a [Position] and some
other
information. For all my 50 employees, I have to go in each record each
day
and put where they worked [Position].

Is there a way I can have the [Position] field in my Employee Table and
act
like a date field? Meaning: I want the [Position] Field to be what it was
for that day, and I want my reports to display that.

IE:

"John Smith" worked in "Section A" on 1/13/09.
"John Smith" worked in "Section J" on 1/14/09.
"John Smith" worked in "Section A" on 1/15/09.

I don't want to have to input that field every day like I am doing right
now. I want it to be defaulted per employee, but changeable in the event
that they move to a different [Position] one day once in a while. I hope
this makes sense.

Thanks

 

[channell]

Wayne,

I have the tables, but I am not sure what to do after that. I am toying
around with it trying to figure out how to get everything working, but I am
not sure what to do next. I made the form, but not everything is working how
it should. Can you help?

Thanks for your assistance!

There are lots of ways to do this.

One simple method would be create
table 1 = employees
table 2 = possitions
tables 3 = DaliyPossitions

table 3 =
DialyPossitionID
employeesID
possitionID
Date
This assumes that each person will not move within the date ??

Next create a continous form based on an updateable query
Set the default possitions for each employee

On Open = message box - do you want to update any employees today ?

If yes - change the emplyees possition
then save

If no - save

Note the daily possiition will be stored as linked record in table 3
This will take a little work to get it to do what you want but not that much.

Good luck
--
Wayne
Trentino, Italia.

Ok, I have a question... I have my employees, and I have an area in the
building in which they are mainly assigned. Now, sometimes they move around
to cover for employees who call in sick or whatever the reason might be, and
I have to change their posistion or the area in which they work.

Each day they have a record with the [Workdate], a [Position] and some other
information. For all my 50 employees, I have to go in each record each day
and put where they worked [Position].

Is there a way I can have the [Position] field in my Employee Table and act
like a date field? Meaning: I want the [Position] Field to be what it was
for that day, and I want my reports to display that.

IE:

"John Smith" worked in "Section A" on 1/13/09.
"John Smith" worked in "Section J" on 1/14/09.
"John Smith" worked in "Section A" on 1/15/09.

I don't want to have to input that field every day like I am doing right
now. I want it to be defaulted per employee, but changeable in the event
that they move to a different [Position] one day once in a while. I hope
this makes sense.

Thanks