Textbox value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Luis,

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

HTH,
Nikos
 
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?
 
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...
 
Back
Top