Display Number of Employees

[pjscott]

I’m using sql2000 and Access 2007.

I want to display the number of employee on the switchboard form. I’ve
created a simple query that has each employee name that totals 704 employees.
I’ve created a Text Box with the Control Source as: =Count
([qryEmpCount].[Name]). But all I get is #Error.

How can get the number of employees to display on the switchboard form?

Thanks,
Paul

 

[RonaldoOneNil]

=DCOUNT("[Name]","qryEmpCount")

 

[pjscott]

Sorry but I still get the #Error. The quey name and field are correct . But
it doesn't seem be recognizing the query. Any ideas?

Thanks,

Paul

=DCOUNT("[Name]","qryEmpCount")

I’m using sql2000 and Access 2007.

I want to display the number of employee on the switchboard form. I’ve
created a simple query that has each employee name that totals 704 employees.
I’ve created a Text Box with the Control Source as: =Count
([qryEmpCount].[Name]). But all I get is #Error.

How can get the number of employees to display on the switchboard form?

Thanks,
Paul

 

[Douglas J. Steele]

Name is a reserved word, and should never be used for your own purposes.
Even though you've put the field name in square brackets, perhaps Access is
getting confused.

Try

=DCOUNT("*","qryEmpCount")


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Sorry but I still get the #Error. The quey name and field are correct .
But
it doesn't seem be recognizing the query. Any ideas?

Thanks,

Paul

=DCOUNT("[Name]","qryEmpCount")

I'm using sql2000 and Access 2007.

I want to display the number of employee on the switchboard form. I've
created a simple query that has each employee name that totals 704
employees.
I've created a Text Box with the Control Source as: =Count
([qryEmpCount].[Name]). But all I get is #Error.

How can get the number of employees to display on the switchboard form?

Thanks,
Paul

 

[pjscott]

Got it. Tried different query and it worked.

Have a good weekend and thanks for the help,

Paul

Name is a reserved word, and should never be used for your own purposes.
Even though you've put the field name in square brackets, perhaps Access is
getting confused.

Try

=DCOUNT("*","qryEmpCount")


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Sorry but I still get the #Error. The quey name and field are correct .
But
it doesn't seem be recognizing the query. Any ideas?

Thanks,

Paul

=DCOUNT("[Name]","qryEmpCount")

:

I'm using sql2000 and Access 2007.

I want to display the number of employee on the switchboard form. I've
created a simple query that has each employee name that totals 704
employees.
I've created a Text Box with the Control Source as: =Count
([qryEmpCount].[Name]). But all I get is #Error.

How can get the number of employees to display on the switchboard form?

Thanks,
Paul

.