Search results

  1. M

    Time difference excluding weekends and holidays in hours from now.

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

    query giving error

    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 <=...
  3. M

    intrumentation time slot

    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...
Back
Top Bottom