Count in Expression Builder in Access
<p>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 <code>Count([Data!A])</code>. When I go to the form view it shows me <code>#Error</code>.Where as the count in Query Data is 20. Where am I going wrong with the syntax? </p>