Search results

  1. S

    help on sql syntax

    Hi to all. i am currently inserting and running a script namely: update tbl_people_directory set [email] = SELECT (FirstName+'.'+MI+LastName+'@accenture.com') AS email FROM qry_missing_Peoples WHERE (((qry_missing_Peoples.Email)=' ')); but the system told me that it encountered a syntax...
  2. S

    Supressing a Field in details section

    good morning. i would like to kindly ask if i can supress a certain field so that is does not appear to be duplicate when i preview the report? hope you can help
  3. S

    Trimming Characters

    Good Morning to all i would like to kindly ask if there is a pre defined function in the VBA SQL of access in which it will trim a certain field programmatically for example Old string = Manila-MSE Building - 30.26f New String = Manila-MSE Building Thanks for your help
Back
Top Bottom