Access Query where i can sum occurrence of particular word

[rahul2310]

I want to add column in the query which will sum the occurrence of word "authorized"
Suppose query returns 1 row as result.
In that one row how many times word "authorized" has occurred
For Example

 employee code    Item 1          Item 2        Sum
       1           Authorized      Not           1
       2           Authorized      Authorized    2
       3           Not             Not           0
 

This Way Plz Help

[zmbd]

You're looking at something along the lines of:

SELECT [pk]
   ,[nId]
   ,[lang1]
   ,[lang2]
   ,IIF(NZ([lang1],0)="a",1,0) 
      + IIF(NZ([lang2],0)="a",1,0) 
      AS sumofa
FROM [tbl_expiment];
)

Ideally you would normalize this db: > Database Normalization and Table Structures.