Count Expression/ calculation

[andreondray]

I'm a little newbie here so please bare with me.

I'm doing a query for a call centre that is to calculate the number of calls for locations over 100k Square foot. However, I want to normalize the calculation by 100k SF. So the calculation should count the call centre work orders and then multiply it by 100k and divide it by the location Area.

I have no clue where to start, below is where I'm at. the new expression that i've added "wo" is where I want to count the total ([CallID]*100000)/[Area]. this isn't working.

 

[pdx_man]

Try:
wo: Count(CallID)*100000)/[Area]

 

[andreondray]

thanks, but I get this error:

"the expression you entered has too many closing parentheses"

Seems like a simple query, but I guess not. any other suggestions?

 

[ajetrumpet]

Andre,

From the screenshot, your query says...

SELECT Count(CallID), [otherfields]

  FROM ()

    WHERE [area] > 100000 AND [company] = "Elmo" AND [callopened] Between {} and {}

This is all OK, however, every GROUP by that you have to include in the query will decrease the number of the COUNT, because Access is counting the DISTINCT records based on the number of fields that are GROUPED. I think this might be a lot easier if you created a separate query to hold just the COUNT of the CallID's that are in the specified criterion. If you can store that number separately, this would be a piece of cake! Doing it that way will provide you with a value that you can use in expressions rather than trying to use one query with expressions and functions mixed together to obtain it.

Another resource that may help...
http://www.access-programmers.co.uk/forums/showthread.php?t=135763