DCount function

[jzacharias]

I am having trouble using the DCount function to return the number of records from two different fields. I am able to return records from one field. Not sure of the correct syntax for multiple fields.

 

[boblarson]

I am having trouble using the DCount function to return the number of records from two different fields. I am able to return records from one field. Not sure of the correct syntax for multiple fields.

You would need TWO Dcounts (one for each table) and then add them together.

 

[jzacharias]

What if it's from a query?

 

[pr2-eugin]

DCount is a Domain Function and can take Table/Query..

 

[jzacharias]

Query is called Total Citations
I want to count total records if Field "Shift" = Days and field "Rotation" = Green

 

[pr2-eugin]

Try..

DCount("*","[Total Citations]","Shift='Days' AND Rotation='Green'")

 

[jzacharias]

I had it like that except for the "*". What does that do?

 

[jzacharias]

...and I used the & instead of "and"

 

[pr2-eugin]

Normally when using a DCount you would not have a specific column to count from.. in other words it does not matter which field it uses to count.. you can specify columns, absolutely nothing wrong in that.. for simplicity we use *..

& - is a concatenating variable.. unlike Java or other programming language & does not mean the Logical AND in VBA..

 

[jzacharias]

By the way, it worked. Thanks

 

[pr2-eugin]

Glad to know it did.. Good luck..