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