Results 1 to 5 of 5

Thread: expressions?

  1. #1
    Join Date
    Sep 2006
    Posts
    28

    Unanswered: expressions?

    help! I have a table and want the status field to read outstanding if it is empty. Do I have to do this with a query and set a new column where if [Status] is null = outstanding becuase I've tried that and can't get it to work!
    any ideas?

    thanks!

  2. #2
    Join Date
    Aug 2004
    Location
    Manchester, England
    Posts
    23
    Have you tried setting the default value for that field to "Outstanding" in the table properties?

    JBee

  3. #3
    Join Date
    Sep 2006
    Posts
    28
    hmmm but I only want it to be outstanding if the preievious date column is after a specified date i.e. [Build date]>date()

  4. #4
    Join Date
    Aug 2004
    Location
    Manchester, England
    Posts
    23
    OK, I would use an expression in my query, something like-

    MyStatus: Iif(tblYourTable.BuildDate>Date(),'Outstanding')

    Good Luck

  5. #5
    Join Date
    Sep 2006
    Posts
    28
    Excelent thankyou that helped alot

    I used:

    Build Status1: IIf(([qu:autodates].[Build by])<Date() And [tb:tool_room].[Build status] Is Null,'O/S',IIf([tb:tool_room].[Build status] Is Not Null,[build status]))

    Thankyou!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •