DCount or Count

[rlan214]

DCount or Count either one doesn't work with my form

So I have this queries already that counts

SELECT Count([Work Request].[Work Request #]) AS [Count of ALL WR]
FROM [Work Request]
ORDER BY Count([Work Request].[Work Request #]);

when I try to copy this on my control source it doesn't do anything
i tried
=DCount("[Work Request #]"," [WRs_All]")
and it doesn't work

i also tried
=Count(WRs_All![Work Request #])

and it still doesn't work
need a lil help pls

oh also I used bound

 

[rlan214]

looks like i just figure it out
i need to use text box my stupid a$$

 

[neileg]

You are using [Work Request] as the table name in the query and [WRs_All] in the DCount statement. Which is it?

 

[rlan214]

You are using [Work Request] as the table name in the query and [WRs_All] in the DCount statement. Which is it?

actually i as using [work request]
its all good now