Graphical Reports

[JMichaelM]

I figured out the data bars as well. THe problem I get when running comparing the records is "Cannot have aggregate function in expression (Min(Count(())) so perhaps I need to build a new query?

 

[Mark_]

I figured out the data bars as well. THe problem I get when running comparing the records is "Cannot have aggregate function in expression (Min(Count(())) so perhaps I need to build a new query?

Count counts up the total in a set. Min would return the minimum from a set.

It does look like you would need two queries, first to return you COUNT, then a second to return the minimum from your set.

I am guessing you are trying to count the total number of records that meet a criteria then work out your minimum and maximum values, correct?

 

[JMichaelM]

Yes, the total comes from a count records query.