Hello,

A database application starts with designing the structure of the data
tables. It doesn't appear you started here. Perhaps what would help you is
some assistance with the design of your tables. I have provided that help
many times to customers and am willing to help you. I charge a small fee to
work with you to design the tables you need. If you want my help, contact
me.

Steve



"barnstar" u59555@uwe wrote in message news:a6eebd713b6a0@uwe...
Hi I am quite new to Access but I am desperate to learn as much as I can
as
fast as I can.

I am currently working on automating an annual leave process at work & am
struggling & need help.

My problem is that I want the user to complete a form selecting the
date(s) &
time(s) of leave they require. The leave pot is in half hour slots for
e.g.
8:00 - 8:30 & so on. There would be a % of leave given on each half hour
which is calculated against a staff in post figure.

Once the user submits the form the db would automatically check the slots
for
each half hourly slot for the time they requested off & return an
immediate
response.

I hope somebody can help me with this problem & it would be much
appreciated.

Thanks in advance