Tai Lung Tai Lung - 23 days ago 6
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

Count([Data!A])
. When I go to the form view it shows me
#Error
.Where as the count in Query Data is 20. Where am I going wrong with the syntax?

Answer

It should read:

Count([Data]![A])

or just:

Count([A])