I am hoping someone may be able to spot the error in my expression below that is resulting in the "Overflow" Access 2007 error message:
Collection Percent: -Round(IIf([Production]<1,0,Sum([Production]/[PP])),2)
This is a select query (not updating any tables) and [Production] and [PP] are two fields available in the table. The result I'm shooting for is that if [Production] is zero, indicate zero, otherwise compute the percent of collection. ([PP] is the amount collected and is a negative number in the table).
Pretty stumped here... Thank you!
Collection Percent: -Round(IIf([Production]<1,0,Sum([Production]/[PP])),2)
This is a select query (not updating any tables) and [Production] and [PP] are two fields available in the table. The result I'm shooting for is that if [Production] is zero, indicate zero, otherwise compute the percent of collection. ([PP] is the amount collected and is a negative number in the table).
Pretty stumped here... Thank you!