Search results

  1. J

    split delimited field into different rows

    Hello sorry my VBA skills are very poor. If I want to add to this and add another field, should we say "Make" How would I add to this code so it splits the colors as per the code below but also includes the 'Make' into each row? ID colors Make 1 white, black, red Crown 2 red, orange Dulux 3...
  2. J

    Query to identify if a time period is between times that pass through midnight?

    Ok, now I understand, I changed the code to - dt_MustStartBy = CDate(DatePart("d", in_ChangeStart) & "/" & DatePart("m", in_ChangeStart) & "/" & DatePart("yyyy", in_ChangeStart) & " " & in_DayStart) dt_MustEndBy = CDate(DatePart("d", in_ChangeStart) & "/" & DatePart("m", in_ChangeStart) & "/" &...
  3. J

    Query to identify if a time period is between times that pass through midnight?

    Strange , date format issue somewhere? Although I set the query to mm/dd/yyyy hh:nn to match yours.
  4. J

    Query to identify if a time period is between times that pass through midnight?

    here you go...
  5. J

    Query to identify if a time period is between times that pass through midnight?

    Yes I changed the query date format to match mm/dd/yyyy hh:nn Still all fail Checking the code it refers to ChangeStart, in_ChangeEnd however the DB has Change_Start & Change_End which I can easily change. Should both these lines refer to ChangeStart?? dt_MustStartBy = CDate(DatePart("m"...
  6. J

    Query to identify if a time period is between times that pass through midnight?

    Hi Plog Many thanks, All the records are returning a value of "Fail"? If I look at the output 957 should = Pass 949 should = Pass 944 should = Pass 943 should = Pass 959 should = Pass 942 should = Pass
  7. J

    Query to identify if a time period is between times that pass through midnight?

    Many Thanks, bit of a brain teaser than looks easy enough but doesn't behave as expected, I've also added in an HRSDIFF because if that exceeds 840mins it means its also failed or spread over multiple days because 18:00 to 08:00 is 840mins.
  8. J

    Query to identify if a time period is between times that pass through midnight?

    Please use the query "Test Query" I forgot to delete the other which links to old tables :banghead:
  9. J

    Query to identify if a time period is between times that pass through midnight?

    As requested, hope this helps, many Thanks
  10. J

    Query to identify if a time period is between times that pass through midnight?

    Yes , Many Thanks, i'll create a version for you.
  11. J

    Query to identify if a time period is between times that pass through midnight?

    In practice it could be different, however I keep the allowed start and end times in a table and refer to the fields. However mainly its 18:00 - 08:00 so I want to focus on these times to ensure every test is correct in this timeframe . I'm finding that mostly what I try works, but certain...
  12. J

    Query to identify if a time period is between times that pass through midnight?

    ActualWorkStart, ActualWorkEnd, AvailableStart, AvailableEnd, Result 09/06/2016 02:00 09/06/2016 05:00:00 18:00 08:00 Fail Sorry Plog, I didn't move the posts honest i appreciate your help, A change can start and end at any time...
  13. J

    Query to identify if a time period is between times that pass through midnight?

    Mainly works But those after Midnight but before 08:00 on the same day fail when they should pass. I wonder if I need to split the time check before midnight and after? CHANGE_START CHANGE_END Result 03/06/2016 22:00:00 04/06/2016 08:00:00 Pass 03/06/2016...
  14. J

    Query to identify if a time period is between times that pass through midnight?

    ActualWorkStart, ActualWorkEnd, AvailableStart, AvailableEnd, Result 1/5/2016 18:00 2/5/2016 08:00 18:00 08:00 = Pass 1/5/2016 17:59 2/5/2016 08:00 18:00 08:00 = Fail 1/5/2016 18:00 2/5/2016 08:01 18:00 08:00 = Fail So...
  15. J

    Query to identify if a time period is between times that pass through midnight?

    I also need to take into account the end date, So the time of the change must not be before 6PM And the end time must be before 8AM So between Start Time 1/5/2016 18:00 And End Time 1/5/2016 08:00 is OK. Start Time 1/5/2016 17:59 And End Time 1/5/2016 08:00 is FAIL Start Time 1/5/2016 18:00 And...
  16. J

    Query to identify if a time period is between times that pass through midnight?

    Hi I'm in the process of designing a database to identify if work can be performed during a time period. I also have to take into account the day of the week but i've done this by testing against the start days allowed which are stored in a table. So for example, a department allows work...
Top Bottom