View Full Version : Count number records


junmart
09-24-2001, 07:54 AM
i want to count the number of records that my query found. i want to place this in a textbox. i know i'm supposed to use "dcount" but i couldnt get it right. will someone please hlep me? thanks in advance!

pdx_man
09-25-2001, 01:28 PM
What is your code for the DCOUNT function?

Re-read the Help in Access for DCOUNT. Check out the example.

For the textbox Control Source property:
=DCOUNT("[TheField]","TheTable","[MyField] = somevalue")

If you're looking for a variable for somevalue, then substitute "[MyField] = somevalue" with "[MyField] = " & me.variablevalue