Sir I have a Place_tbl with Field name Place e.g
A, L, M, N
B, L, M, N
C, L, P, N
D, I, Q, O
E, L, M, N
F, J, H, X
G, L, M, N
for working out the count of
Only M
Only N
Not Like N
Not like M but like N
for which expression are
Count(IIf(([Place_tbl].[Place]) Like "*N*",1,Null)) AS WithinN
Count(IIf(([Place_tbl].[Place]) Not Like "*N*",1,Null)) AS OutsideN
Count(IIf(([Place_tbl].[Place]) Like "*M*",1,Null)) AS WithinM
Can we make a expression to where we can count place with criteria
Like M and N
Not Like M But like N
Please guide
A, L, M, N
B, L, M, N
C, L, P, N
D, I, Q, O
E, L, M, N
F, J, H, X
G, L, M, N
for working out the count of
Only M
Only N
Not Like N
Not like M but like N
for which expression are
Count(IIf(([Place_tbl].[Place]) Like "*N*",1,Null)) AS WithinN
Count(IIf(([Place_tbl].[Place]) Not Like "*N*",1,Null)) AS OutsideN
Count(IIf(([Place_tbl].[Place]) Like "*M*",1,Null)) AS WithinM
Can we make a expression to where we can count place with criteria
Like M and N
Not Like M But like N
Please guide