Search results

Thanks for a early reply but it not working When I inter =DCount("[Rank]","Basic_Info","[Rank] = 'HS-I'" and “[Inactive] =’False’”) message appears that "The expression you entered contains invalid syntax, You may have entered an operand without and operator" and when i entered...

I have a employees table which contains following fields:- (a) Rank (b) Name (c) Trade (d) Date_of_Induction (e) Marital_Status (f) Living_Status (g) Inactive (Check Box) when I enter =DCount("[Rank]","Basic_Info","[Rank] = 'HS-II'") in unbound box it counts all active & inactive employees, but...