S smoke Registered User. Local time Yesterday, 21:47 Joined Sep 2, 2004 Messages 18 Sep 10, 2004 #1 how do i get thetotal number of records off a table? right now im using count(table!field) but when i filter my form it filters the total number, thanks for the help-
how do i get thetotal number of records off a table? right now im using count(table!field) but when i filter my form it filters the total number, thanks for the help-
I irini New member Local time Today, 05:47 Joined Jun 17, 2003 Messages 9 Sep 10, 2004 #2 Try using dcount("field","table")
S smoke Registered User. Local time Yesterday, 21:47 Joined Sep 2, 2004 Messages 18 Sep 10, 2004 #3 hmm having trouble to get dcount working, .. any other suggestions? im doing =dcount("table","field") in the controlsource..
hmm having trouble to get dcount working, .. any other suggestions? im doing =dcount("table","field") in the controlsource..
S smoke Registered User. Local time Yesterday, 21:47 Joined Sep 2, 2004 Messages 18 Sep 10, 2004 #4 oh wait duh, nm