Display Number of Employees

  • Thread starter Thread starter pjscott
  • Start date Start date
P

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
 
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

RonaldoOneNil said:
=DCOUNT("[Name]","qryEmpCount")

pjscott said:
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
Click to expand...
Click to expand...
 
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!)

pjscott said:
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

RonaldoOneNil said:
=DCOUNT("[Name]","qryEmpCount")

pjscott said:
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
Click to expand...
Click to expand...
Click to expand...
 
Got it. Tried different query and it worked.

Have a good weekend and thanks for the help,

Paul


Douglas J. Steele said:
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!)

pjscott said:
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

RonaldoOneNil said:
=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
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top