How do i input multiple dates in one Access Field

[Don]

Hello,

I am trying to create a staff scheduling system for my new company. I have
many tables set but have got stcuk on one, this is the employee availability
table. I have free lance staff, so they will notify me of their availaility
for the month, this could be at different times of the month.

I thought about keeping many fields for the availaiblity but i think this
would get messy when i start to program the DB to allocate work for these
employees. I have found the calender tool on access but can not figure out
how i can sort this litle problem out.

How can i achieve this ? I want to store many different dates for one
employee, which are going to be used to allocate work.

I appreciate anybody taking the time to read this and i look forward to any
ideas and suggestions.

I am a novice user, sorry !

Thank you

 

[Duane Hookom]

I would not place multiple data values in a single field. Consider one
record per staff per date available.

 

[Don]

Thanks for your quick response,

So would it be better for me to put in lots of fields just incase they are
free at lots of different times in the month. If this is the case then be it
but i was hoping there would be compacter and easier solutions.

sorry to sound stupid and be a pain, thanks again

Don

 

[John Vinson]

How can i achieve this ? I want to store many different dates for one
employee, which are going to be used to allocate work.

Then you need a new table, with fields for the employeeid and the
date. For each date that an employee is allocated, you'ld add a new
record to this table (probably using a Subform off the Employee
form.).

John W. Vinson[MVP]

 

[Rick B]

Noooo. A table with the person and date. Mutliple dates would equal
multiple records...


John Dec 13
John Dec 14
Hank Dec 13
Hank Dec 14
Hank Dec 15
Hank Dec 16



Basically, a one-to-many relationship

 

[Don]

Thank you all for your advice, i will apply this to my system.

i will be cecking the discussion board on a regular basis, so if anyone has
any more suggestions then please feel free to post them.

Thanks again