Forms q

[rlan214]

kind of a newb question
but can I show in a form(in a box or something) a number from a querry that I created

the sql ver of my query is like this
SELECT Count(Inprocess.PartNumber) AS CountOfPartNumber
FROM Inprocess
GROUP BY Inprocess.Status
HAVING (((Inprocess.Status)=8));

thanks

 

[RuralGuy]

Have you looked at DCount()?

 

[rlan214]

Have you looked at DCount()?

not really im kinda of a newb but reasearching right now

I thought that after I did a query, that I can just show my answer in a box in my form

but im reasearchin dcount

 

[RuralGuy]

Set the ControlSource of your TextBox to =DCount(... and the answer will be there.

 

[rlan214]

=DCount("PartNumber","Inprocess","Status=8")

is the answer
thanks a bunch
really happy now
just wondering how'd you know to use Dcount instead of count
I mean did you have reference or just flat out really great Access skills
cuz I'm trying to find a really good access book right now

 

[RuralGuy]

Just time in the saddle I'm afraid. I have the wrinkles to prove it.

 

[rlan214]

wrinkles eh or AKA wisdom marks
well either way thanks a bunch
I really appreciate

 

[RuralGuy]

Glad I could help.