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!
|
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 |