Search results

  1. L

    get the next record and compared dates

    Hi, I have been googling around for this question but I'm still lost. I have the following table: case number action date 1 calll 1/1/2014 1 UMAIL 1/1/2013 2 report 3/5/2015 2 umail 4/6/2014 3 final 6/5/2011...
  2. L

    concatenate

    Hi, Not sure I have to pass by the concatenate build-in fonction. I have a table such as : col 1 col 2 (is a memo field) 1 a 1 b 1 c 2 d 2 e I want the output to be like this with new columns : col 1 col2 col 3 col 4 1 a b c 2...
  3. L

    displays queries

    Hi, I have a database from sharepoint which has 250 fields based on a survey. I imported the database into Access where I made 10 queries. I want to know is there a way to display those 10 queries in one queries or in one form. Given that some queries has result to display and others...
  4. L

    update query

    Hello, I have a field with given names such as : Mrs Gordon Mrs Doyer King Larry I would like to remove only the Mrs title in the field in order to have only the given names without the title Mrs : Gordon Doyer King Larry So far I tried a update query : UPDATE [Copy Of matched...
Back
Top Bottom