UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> dcount in query    
 
   
csgnv2
post Sep 10 2004, 09:13 AM
Post #1

UtterAccess Addict
Posts: 181
From: belgium
how can I use the dcount function in a query ?
does somebody have an example?


TIA
Go to the top of the page
 
+
Imitation9
post Sep 10 2004, 09:20 AM
Post #2

UtterAccess Veteran
Posts: 471
From: Little Rock, Arkansas
DCount("FieldCounted","FromWhere","CriteriaStatement")

DCount("Homers","tblBaseball","Name=" & [PlayerName])
Go to the top of the page
 
+
csgnv2
post Sep 10 2004, 09:29 AM
Post #3

UtterAccess Addict
Posts: 181
From: belgium
must i put this in the createrias of an field?

thx
Go to the top of the page
 
+
Imitation9
post Sep 10 2004, 10:37 AM
Post #4

UtterAccess Veteran
Posts: 471
From: Little Rock, Arkansas
In the Field Part ;;; MyField: Then DCount
Go to the top of the page
 
+
csgnv2
post Sep 10 2004, 11:11 AM
Post #5

UtterAccess Addict
Posts: 181
From: belgium
thx for your time
Go to the top of the page
 
+
Imitation9
post Sep 10 2004, 02:33 PM
Post #6

UtterAccess Veteran
Posts: 471
From: Little Rock, Arkansas
Not a problem. Always a pleasure to be of some assistance.

Have a wonderful weekend!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 10:15 AM