Count number records

[junmart]

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]

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