Textbox value

L

Luis

Hello.
I have a textbox where that i'd like to populate with the result of a
"SELECT COUNT..." Sql command.

Is this possible?

Thanks
 
N

Nikos Yannacopoulos

Luis,

In order to count records in a table/query meeting certain criteria, use
function DCount() instead; look it up in help.

HTH,
Nikos
 
L

Luis

Hello Nikos.
I'm having a proble using Dcount. I have a table with a field with the
client code and another Yes/No type field. Then i have a form where i choose
a Client Code and i want that on a certain textbox the number of records for
that client that has the Yes/No field = Yes.

I'm not seem to be able to do this ?

Can you give me a hint?
 
L

Luis

Found the problem!

Luis said:
Hello Nikos.
I'm having a proble using Dcount. I have a table with a field with the
client code and another Yes/No type field. Then i have a form where i choose
a Client Code and i want that on a certain textbox the number of records for
that client that has the Yes/No field = Yes.

I'm not seem to be able to do this ?

Can you give me a hint?
Click to expand...
 
Top