intrumentation time slot

[medioman]

Hi all,

I would like to create a form using access inputting the date and number of hours required on that day and returning available intrument name and time slots.

I will be using this to facilitate planning testing slots for a particular instruments.


I created a table which has the following fields hplc name (name of instrument ie. HPLC 1, HPLC 2, test name ( assay) , start (date time ie. 06/06/2013 11:30), end (date time ie. 06/06/2013 22:30)

I am new to access so I would like to know if anyone can guide me trough.

 

[medioman]

attached where i have arrived till now but still no success

 

[jdraw]

It would be beneficial to readers, and would probably get you more answers, if you would describe WHAT you are trying to do in a clear, plain English paragraph.

There is no context to your post.
Is this a loaning instrument database? What role do you play? Is there a business associated with the proposed database? Are there any business facts you could tell us?

What exactly does this mean?

I will be using this to facilitate planning testing slots for a particular instruments.

Remember our only understanding of you and your issue is based on what you have typed.

 

[medioman]

Firstly I would like to appologise for the lack of information. I am a laboratory technitian in a university. Basically, we have 11 instruments in the lab and we would like students to book and plan the instruments trough a booking system. I would like to check trough a list of instruments, check which are reserved/ list available with available time and then book and avoid double booking.

I really hope this time i gave enough information

 

[medioman]

Attached is what I have done so far but I'm not 100% happy I would like to just input start date and amount of hours required and would like it to list all the slots available on that particular date.

Any ideas please ?

 

[medioman]

Wasn't I clear enough again ?