Hello
I have this string “ACCR 9/30 RECR BNS 03058864”
I need to build the where statement in a query that will look at the first 4 characters and the characters after the date. So in this example it should look at “ ACCR” and “RECR BNS “
This is an example of what am trying to do …
strSql = " UPDATE Tbl_Report_Download SET Tbl_Report_Download.[Line Item] = 'Recruiting Bonus Accrual'" & _
" WHERE (((Left([DESC 1],3))='REV')) And Tbl_Report_Download.[CORP ORG SECOND LEVEL] ='46A' And (Right([DESC 1],3)='BNS') ;"
DB.Execute strSql
Thanks
I have this string “ACCR 9/30 RECR BNS 03058864”
I need to build the where statement in a query that will look at the first 4 characters and the characters after the date. So in this example it should look at “ ACCR” and “RECR BNS “
This is an example of what am trying to do …
strSql = " UPDATE Tbl_Report_Download SET Tbl_Report_Download.[Line Item] = 'Recruiting Bonus Accrual'" & _
" WHERE (((Left([DESC 1],3))='REV')) And Tbl_Report_Download.[CORP ORG SECOND LEVEL] ='46A' And (Right([DESC 1],3)='BNS') ;"
DB.Execute strSql
Thanks