Recent content by Gismo

  1. G

    Gantt Chart

    Hi all, Please could you perhaps point me in a direction to create a report similar to a Gantt chart I am not sure how to approach this I have a list of personnel They need to go on a trip for period x, return, and go on leave for a period Not all the personnel have the same rotation and...
  2. G

    PDF reader

    It open is a web browser, but then gives an error, going to design and back to view displays the document
  3. G

    PDF reader

    Hi all, I have a saved PDF which I link to a form I het a message that there is a problem with adobe, If it is running, please exit and try again When I go to form design and back to form view. the PDF shows correct I am not sure how to correct this problem
  4. G

    DateDiff Query without weekends

    Thank you so much for the help It looks good so far I will test it in the next few days
  5. G

    DateDiff Query without weekends

    So what I need is to know what is the difference in days from date() to Requirement Date I will need a negative days to offset to the amount of days to have the item issued the same day
  6. G

    DateDiff Query without weekends

    Let me try Need to do some exports Please stand by
  7. G

    DateDiff Query without weekends

    That is my material number and Date field
  8. G

    DateDiff Query without weekends

  9. G

    DateDiff Query without weekends

    Doesnt seem to work on my side, might be missing something
  10. G

    DateDiff Query without weekends

    I have no idea how to do this though
  11. G

    DateDiff Query without weekends

    Hi all, Please could you assist? I have to calculate the difference between 2 dates excluding weekends but not sure how
  12. G

    Display text if a condition is met

    I removed the table reference, still no luck also tried
  13. G

    Display text if a condition is met

    Hi all, Please could you assist? in a query If condition 1 is >=1 and condition 2 is >= 1 Display text Else do nothing I tried the below as a test but I get a expression invalid syntax Below only shows one condition as a test
  14. G

    Concatenate and resize text

    Hi all, Please could you assist? I need to resize the second concatenation to a smaller text size (Reference 1) only
  15. G

    Concatenate number and symbol

    Thank you so much Looks good
Top Bottom