How do i input multiple dates in one Access Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 20 Dec 2004 15:59 GMT

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

Reply to this Message

Duane Hookom - 20 Dec 2004 16:15 GMT

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

Signature

Duane Hookom
MS Access MVP
--

> Hello,
>
[quoted text clipped - 20 lines]
>
> Thank you

Reply to this Message

Don - 20 Dec 2004 17:51 GMT

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

> I would not place multiple data values in a single field. Consider one
> record per staff per date available.
[quoted text clipped - 23 lines]
> >
> > Thank you

Reply to this Message

Rick B - 20 Dec 2004 18:13 GMT

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

> Thanks for your quick response,
>
[quoted text clipped - 33 lines]
> > >
> > > Thank you

Reply to this Message

John Vinson - 20 Dec 2004 18:07 GMT

>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]

Reply to this Message

Don - 21 Dec 2004 12:12 GMT

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

> >How can i achieve this ? I want to store many different dates for one
> >employee, which are going to be used to allocate work.
[quoted text clipped - 5 lines]
>
> John W. Vinson[MVP]

Reply to this Message