Choose function with parameters (1 Viewer)

BDarden

New member
Local time
Today, 14:57
Joined
Dec 27, 2013
Messages
1
I'm really hoping someone can help me, I can not figure out what I'm doing wrong, I have query set up as such:

UMMonth1: Choose([Enter Qtr],[OperationsAuditData]![1],[OperationsAuditData]![4],[OperationsAuditData]![7],[OperationsAuditData]![10])

But I keep getting an error message "You tried to execute a query that does not include "UMMonth1: Choose([Enter Qtr],[OperationsAuditData]![1],[OperationsAuditData]![4],[OperationsAuditData]![7],[OperationsAuditData]![10])' as part of an aggregate function."
 

jdraw

Super Moderator
Staff member
Local time
Today, 15:57
Joined
Jan 23, 2006
Messages
15,379
Please post your entire query.
For more info on Choose function see
 

Brianwarnock

Retired
Local time
Today, 20:57
Joined
Jun 2, 2003
Messages
12,701
Aggregate functions are those that appear in the drop down list on the Totals row in the design grid, if one column contains one of these then all columns must , presumably Choose is not one.

Brian
 

Users who are viewing this thread

Top Bottom