Search results

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

    Concatenate number and symbol

    No, That code gives the same error Refer to post #3
  17. G

    Concatenate number and symbol

    With my code, this is what I get I used the + before and also got the error
  18. G

    Concatenate number and symbol

    This is what I tried I get an #Error when there is no data in Limit 2
  19. G

    Concatenate number and symbol

    Hi all, Hope you are well I tried to concatenate with + if there are no data but getting errors Limit 1 and Unit 1 will always have data Limit 2 and Unit 2 might not always have data If Limit 2 has no data, I don't want to show the "/" Please could you assist?
  20. G

    Replace

    Excel and word was having issues not opening after the reinstall, excel wont calculate a basic function The query was for Access
Top Bottom