Tai Lung Tai Lung - 1 year ago 75
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?

Answer Source

It should read:


or just:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download