Recent content by yetirider

  1. Y

    Trim to leave charters between charter |?

    Thats great, understand that example. Many Thanks Phil
  2. Y

    Trim to leave charters between charter |?

    Thanks, not sure how to implement that. In the mean time i've used InStr to count the number of charters up to the second | and the third |. Just need a way so it correctly shows the text in between.
  3. Y

    Trim to leave charters between charter |?

    Hi In a field i have text in the format XX|XXXXXX|TEST|X|XX|XXX|XXXXXXXXXXXXX X represents text that may be in the fields and will vary in length. I need to extract the text after the second | and before the third | So in the example above I would just be left with "TEST". Could someone help...
  4. Y

    VBA to spit cell into rows with matching row data

    SOLVED Re: VBA to spit cell into rows with matching row data I managed to achieve to required output in Excel using the code on this webpage. http://access-excel.tips/excel-separate-line-break-into-rows/
  5. Y

    VBA to spit cell into rows with matching row data

    This is the required output
  6. Y

    VBA to spit cell into rows with matching row data

    This is my base data
  7. Y

    VBA to spit cell into rows with matching row data

    Please move if this would be better in a different forum.
  8. Y

    Email Report

    That looks like really useful code - thanks
  9. Y

    VBA to spit cell into rows with matching row data

    (SOLVED) VBA to spit cell into rows with matching row data Hi Must admit I don't have a clue how to resolve this. I have data which i import into a database from a text file. One of the fields has multiple entries. I need to to extract this data into new rows and also copy to other data that...
  10. Y

    Identify time slots used to perform a piece of work

    That worked perfectly thanks, just had to reformat the data and convert the minutes into hh:nn Many thanks for your help its really appreciated .
  11. Y

    Identify time slots used to perform a piece of work

    Many Thanks Will download review the code.
  12. Y

    Identify time slots used to perform a piece of work

    Hi I have a number of time slots that cover a 24Hr period. I need to identify which time slots a piece of work occupies and how much slot time it would use. So the slots are:- Name Start End SLOT_MINS Early 00:01 01:59 118 Morning 02:00 06:59...
  13. Y

    Adding a number of hours to a general date

    Yes looking at the data it was in a text format although it looked like hh:nn reformatted to date and it works fine, thanks for the clue.
  14. Y

    Adding a number of hours to a general date

    Hi Within a query i have a general date field in the format dd/mm/yyyy hh:nn. I have a field that holds the number of hours a job will take in the format hh:nn. If I add the field names - TASK_END_TIME: [Planned_Start]+[TASK_TIME] This give me #Error. How can I add a number of hours to a date...
  15. Y

    Split a string where you know the before and after but need the middle

    Hi How can I split a string in the query where I know the start and the part that comes after the text I need? The string forms a file location and I need to extract the application name which will vary in name /data1/ur/application name/file/etc /data1/ur/amdocs/file/etc...
See more
Top Bottom