Expression Error in IIF statement

A

ashchak

New member
Local time
Today, 02:15
Joined
Aug 9, 2016
Messages
5
Expr1: IIf(CDate([Weekly_Upload].[Gift Date])>[Transaction_Failed].[Gift Date],"Success","Failure")

Getting error in this expression
Error : Your Query does not include specified expression as a part of aggregate function.
 
Most likely you are trying to list this expression in your query but you haven't included it in the group by clause.

Please post the rest of your query.
 
You must log in or register to reply here.

Similar threads

D
Solved Combining IIf Statements
3 4 5
Replies
91
Views
1,821
DHookom
DHookom
D
Solved syntax error (comma) in query expression
Replies
4
Views
256
dullster
D
D
Solved Nesting IIF Statement with functions that end in (field)
Replies
13
Views
326
arnelgp
arnelgp
S
Solved Using a Does Not Contain Criteria in an IIf Statement
Replies
9
Views
362
Pat Hartman
P
F
Your Query does not include the specified Expression ‘ID’ as part of an Aggregate Function
Replies
8
Views
664
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom