Re: Struggling w/ the IIF function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Graham R Seach (gseach_at_NOSPAMpacificdb.com.au)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 13:22:59 +1000

At first glance, it looks just fine.

Where are you executing this lot from? It looks like you're executing it
from a query.

What are the data types and expected values of each operator?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

"batersmom" <batersmom@discussions.microsoft.com> wrote in message
news:D672F651-2C01-4017-9512-C40955089E43@microsoft.com...
> I am entering the function below but I only get my true results it does
not bring in the false results.
>
> IIf([Open Activity Report]![Group #]=[Group Information]![Group
Number],[Group Information]![Group Name],"verify group")
>
>

Relevant Pages

  • Re: on open and before exit events
    ... Are you sue that line of code is executing? ... Insert a Stop or msgbox ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Debugger not stopping at breakpoint
    ... The code is executing. ... It doesn't matter where I put ... the breakpoints. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: INSERT syntax error
    ... Where do you get the error, trying to open the connection or executing ... Can you execute the query successfully in a microsoft access query ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Struggling w/ the IIF function
    ... your formula needs to account for Nulls: ... Microsoft Access 2003 VBA Programmer's Reference ... It looks like you're executing it ... > Microsoft Access 2003 VBA Programmer's Reference ...
    (microsoft.public.access.gettingstarted)
  • Re: Replaced BE with SQL db; slowdown on load?
    ... before the user interface is responsive, ... importantly, is there a way to delay loading of the startup form, or ... Is the problem before any of your code starts executing or during the execution of ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)