Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Y

    Hi all

    Hi My names Phil I like using access but always have a question. Thanks for your help.............
Top Bottom