Tai Lung Tai Lung - 7 months ago 37
SQL Question

Count in Expression Builder in Access

I have a Query named Data and it has 5 fields A, B ,C ,D, E. The Field A has always distinct values. I have form with where I have an unbound textBox. Through the Expression Builder for the text box. I use

. When I go to the form view it shows me
.Where as the count in Query Data is 20. Where am I going wrong with the syntax?


It should read:


or just: