Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DCOUNTIF?

Status
Not open for further replies.
RandDUser

RandDUser

Technical User
Joined
Feb 24, 2005
Messages
65
Location
US
I have the following DCount statement in my VBA:

DCount("[Quantity]", "tbl_Main")

This obviously counts all of [Quantity], but I want to be able to count the quantity of only records where FieldX in the same table equals 'Team'. I can't figure out how to add in the WHERE statement in my DCount.

Any help is appreciated. TIA.
 
Sort by date Sort by votes
Code: 
DCount("[Quantity]", "tbl_Main","FieldX =''Team''")
 
Upvote 0 Downvote
sory SB
Code: 
DCount("[Quantity]", "tbl_Main","FieldX ='Team'")
 
Upvote 0 Downvote
That was easy, thank you!
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top