I am NOT a DB person, just create my own using the canned product. I am trying to create a chart using totals, which is easy, except that I want to divide the totals by certain numbers depending on certain things. I went into the design view and tried the following in a blank column:
I got an error about quotation marks needing to be around all text. I am not sure that the expression would work anyway. I was going to try using the Totals Row as "Count", but couldn't figure how to get that count figure into my IIF expression.