Recent content by Stylez

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

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

These Values are the actual fields in the database in which i need to truncate. Old string = Manila-MSE Building - 30.26f New String = Manila-MSE Building your assistance is gladly appreciated

Yes i am truncating on the right. may i ask if you have a sample code or sql query in which you use the instrrev function? Thanks

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