Help with displaying a count on a form

  • Thread starter Thread starter KAK
  • Start date Start date
K

KAK

I have created 2 queries that count distinct project numbers from a table in
my Access data base.
Query1 Called QryCntProject1
SELECT tblProjects.[Project Nbr]
FROM tblProjects
WHERE (((tblProjects.[Actively Reporting])=Yes))
GROUP BY tblProjects.[Project Nbr];

Query2 Called QryCntProjects2
SELECT Count(qryCntProjects1.[Project Nbr]) AS CntProjects
FROM qryCntProjects1;

Then on my form I place a text field with the control source of
=[qryCntProjects2]![CntProjects]
the value returned is #name
The query runs fine but I cannot get it to display on the form.
What am I doing wrong?
Can someone please help?
 
use: = DLOOKUP("CntProjects", "qryCntProjects2")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
You don't need the 2nd query. In the controlsource of your text box put this

=DCount("[Project Nbr]","QryCntProject1")
 
Thanks Dale this works fine!

Dale Fye said:
use: = DLOOKUP("CntProjects", "qryCntProjects2")

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



KAK said:
I have created 2 queries that count distinct project numbers from a table in
my Access data base.
Query1 Called QryCntProject1
SELECT tblProjects.[Project Nbr]
FROM tblProjects
WHERE (((tblProjects.[Actively Reporting])=Yes))
GROUP BY tblProjects.[Project Nbr];

Query2 Called QryCntProjects2
SELECT Count(qryCntProjects1.[Project Nbr]) AS CntProjects
FROM qryCntProjects1;

Then on my form I place a text field with the control source of
=[qryCntProjects2]![CntProjects]
the value returned is #name
The query runs fine but I cannot get it to display on the form.
What am I doing wrong?
Can someone please help?
Click to expand...
Click to expand...
 
Back
Top