DCount and If

[Madmax]

Good Morning,



Trying to find the correct way to use an if statement inside of a DCount or vise versus.

Basically the literal will be: If [Table]![Item 1] has a date (isdate) then If [Table]![Item 2] is yes then DCount all the yes's that has that date only.


the final formula is going to have up to 8 items to check for different counts but I just need an example with two and I can figure out the rest.

Thank you,

[pbaldy]

Try

DCount("*", "TableName", "IsDate(Item1) AND Item2 = True)

[rpeare]

I would not try to do a dcount of 8 different items, can you construct a query that shows the information you want? if so it would likely be easier and faster for your database to just read the content of the query and then perform whatever action you need based on the result it finds.

[Madmax]

Actually, that did end up working better. created a sub report inside the original report with a pivot chart still working the kinks though