Solved Form to show totals using dCount with multliple criteria (1 Viewer)

[kengooch]

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.

 

[bob fitz]

Try:
=DCount("*","tMwvEvnt","[tFacility] = 1 AND [tEvntType] = 1")

 

[Gasman]

If more than one criteria, I tend to put it all into a string variable and the debug.print it. That way you can see your errors?

 

[Pat Hartman]

Rather than hard-coding all the values, use a totals query and display it in a subform or listbox. It will be far more efficient and not require constant maintenance as the data changes.

 

[kengooch]

Try:
=DCount("*","tMwvEvnt","[tFacility] = 1 AND [tEvntType] = 1")

That worked perfect!! thanks so much

 

[Pat Hartman]

Hope you don't have to add a new facility or a new event type.

 

[bob fitz]

That worked perfect!! thanks so much

Glad it worked for you.

I would advise you to give consideration to Pat's comments in post #4. I've always found her advice to be worth its weight in gold.