On Mon, 30 Jan 2006 15:34:27 -0800, pas926 <pas926@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I'm using Access 2002
>I have an IIF statement in my query
>"DGPSN: IIf([QuickBook]=6,55,50)
>When I run this in my forms it works fine, but in the query I get "#Error"
>Don't know why it won't work.
>Any help would be appreciated.
>Thanks Paul
Please open the Query in SQL view and post it here. Is there in fact a
field named QuickBook in the table upon which the query is based? It
might work on the Form because there's a Control of that name.
Re: Can an IIf Statement return more than one value ... I am new to VBA but would like to continue to learn more. ... best way to open the query on VBA I am guessng an "On Click" Or 'On Focus" ... appears as the RowSource for your combo box (with the RowSourceType set to ... saying that you want the IIf statement to select multiple rows from the ... (microsoft.public.access.formscoding)
Re: Find - replace automatic ... So there was a quote just before the first IIF statement?...Microsoft Access MVP... and ran an Update query against that field. ... you can handle the ApprovalStatus updates... (microsoft.public.access.gettingstarted)
Re: Getting Rid Of .NET Splash Screen ... > fixed the problem without my needing to do "run control... > responded to my query....William...Prev by Date: ... (microsoft.public.windowsxp.help_and_support)
Re: Need help with a query ... You can use the IIf statement in queries: that's an "Immediate If", ... IIf(expr, truepart, falsepart) ... If expr is true, the function returns truepart.... Is this possible for a query.... (microsoft.public.access.gettingstarted)
