kengooch
Member
- Local time
- Today, 15:07
- Joined
- Feb 29, 2012
- Messages
- 137
I have a form that shows totals in several unbound text boxes. For example in my tMwvEvnt Table I only want to count records whose tEvntType =1 so I use =DCount("*","tMwvEvnt","tEvntType = 1") and it works great.
But I also need to count the records where "tEvntType" = 1 and "tFacility" = 1
I tried several things similar to this...
=DCount("*","tMwvEvnt","[tFacility] = 1 & and & "tMwvEvnt","[tEvntType] = 1")
But I keep getting a syntax error.
Any help would be appreciated.
But I also need to count the records where "tEvntType" = 1 and "tFacility" = 1
I tried several things similar to this...
=DCount("*","tMwvEvnt","[tFacility] = 1 & and & "tMwvEvnt","[tEvntType] = 1")
But I keep getting a syntax error.
Any help would be appreciated.