Results 1 to 2 of 2
  1. #1
    tallroger is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    1

    What's wrong with this expression


    Here is the expression I put in the "Field".0730: IIf(#7:30:00 AM#>=[TimeoffTable]![Starttime] And #7:30:00 AM#

  2. #2
    CraigDolphin is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Apr 2009
    Location
    Custer, WA, USA
    Posts
    125
    Well, for starters you're missing the two other arguments required by an iif expression.

    An iif contains three arguments inside the brackets:
    1. The logical test followed by a comma
    2. The result to return if that test is true followed by a comma
    3. The result to return if that test is false

    So, from what I see in your post you have only the logical test component, and neither of the other required arguments, and you haven't even closed the bracket.

    Even worse, your logical test is either incomplete or very muddled. It's like you trail off in the middle of a sentence or something.

    Can you explain in english what exactly you want this field to return under what conditions?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compiler WRONG example-DB
    By pacala_ba in forum Access
    Replies: 12
    Last Post: 04-18-2009, 01:00 PM
  2. What am I doing wrong?
    By brandon in forum Access
    Replies: 2
    Last Post: 08-03-2008, 10:26 AM
  3. DMax returning wrong value
    By nedbenj in forum Access
    Replies: 7
    Last Post: 10-24-2007, 10:30 AM
  4. What I am doing wrong? (caption of report)
    By swampdonkey in forum Reports
    Replies: 0
    Last Post: 12-07-2006, 11:07 AM
  5. Week number wrong
    By Nikki17 in forum Queries
    Replies: 6
    Last Post: 03-18-2006, 10:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums