Trouble with dates

[Tuulia]

I'm designing a database which should have information about presence at
work, holidays, etc. I would like the collegues to fill it up eg. present
2.11-5.11.07, business trip 6.11.07 etc., but I do not find information how
to connect the date to each action. If I add a date to one field, it shows in
all fields, and if I change it it snahges for each of the actions.

Do I need to create a macro for each "action" and date? Any suggestions?

Thanks ppl!

 

[Rick B]

Wouldn't this be much easier in Microsoft Outlook's calendar?

If you add a date to one field it shows in all fields? What does that mean?
Every single field in your database is filled in with a date that you enter
in any field?

Please be more specific. What is your table(s) structure? What are your
field names and types? Where are you entering this data (in a form)? Give
us a specific example of an entry and what happens vs. what should happen.

Also, if this is being used by many people, I'd think you would need to know
the person associated with each item. Do you have a "people" table?

You say you want them to enter the fact that they were at work from November
2 through 11. How are they doing that? Do you have a form with a start and
stop date field and then code to go out and create an item for each date in
the range? What about weekends?

We would need many more details before we could give you a constructive
answer.