Re: Enter Parameter Value despite no Parameter in query
Because of the order the clauses are evaluated in, you can't use the alias in the group by clause. You can try switching to SQL view and change
GROUP BY CardsWithFuses
GROUP BY IIf([Device Definition].[DeviceType]="RTU",(-Int([IOwithfuses]/(-16))),(-Int([IOwithfuses]/(-32))))
Microsoft Access MVP 2007-2019
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.