Want a Field on a Form that Puts a Total From a Query 2

[hext2003]

I have a summary Query that tells how many records are pending (Field Pending = true)

Query works fine

I have a Summary form where I want to put

You have ______ Contracts Pending

Where the blank is the number from the query..

I did a Bounded Text Box with a source of =ToProcess![Count Of Process] (ToProcess is the Query, Count of Process is the total pending)

I get a blank and should get a 27... what am I doing wrong? is there an easier way?

 

[Remou]

You need to use a domain aggregate function. DlookUp may suit.

=DlookUp("[Count Of Process]","ToProcess")

 

[hext2003]

i Tried a

=count «Expr» [Contracts]![Finished] = False

to count right from the table...

I tried your Dlookup from prev post

I just get a flickering Text Box no values....

 

[Remou]

Please post the SQL of the query.

 

[hext2003]

SELECT DISTINCTROW Process_Parcel.Finished, Count(*) AS [Count Of Process_Parcel]
FROM Process_Parcel
GROUP BY Process_Parcel.Finished
HAVING (((Process_Parcel.Finished)=False));

 

[Remou]

Does this work?

New query:

SELECT Count(*) AS [Count_Process_Parcel]
FROM Process_Parcel
WHERE Process_Parcel.Finished=False

=Dlookup("[Count_Process_Parcel]","PutNameOfQueryHere")

 

[PHV]

=DCount("*","Process_Parcel","Finished=False")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hext2003]

thank you!!!