Recent content by medioman

I would like to add time elapsed since an entry was made excluding weekends public holidays and calculating 8 hours a day (from 6am to 2 pm) since the entry was made till the generation of the report. Any ideas how shall I approach this in terms of programming ? Thanks alot for your time.

table booking ---------------------------------------------------------------------------------------------------------------------------- | ID | HPLC | StartDate | Testing | EndDate |...

I have the code below and it is giving me an error SELECT hp.* FROM hplcslot_dc AS hp INNER JOIN Booking ON hp.HPLC = Booking.HPLC WHERE (((hp.id) Not In (SELECT hplcslot_dc.id FROM Booking INNER JOIN hplcslot_dc ON Booking.HPLC = hplcslot_dc.HPLC where (Booking.startdate <=...

Wasn't I clear enough again ?

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 ?

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

attached where i have arrived till now but still no success

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