Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Show field IF....

Discussion in 'Information Technology' started by MarieK, Jul 28, 2006.

Tags:
  1. MarieK

    MarieK
    Expand Collapse
    Guest

    I am going crazy trying to figure this out....

    I have a benefits database. In my query one of the fields in an
    expression(calculation). I do NOT want this field to show if the employee is
    not 366 days past the [hire date].

    how can I do this?? the IIF statements don't seem to be working...but
    perhaps I am doing it wrong...

    Thanks in Advance for any help!!!
     
  2. Loading...


  3. access user

    access user
    Expand Collapse
    Guest

    can you post your IIF statement?

    "MarieK" wrote:

    > I am going crazy trying to figure this out....
    >
    > I have a benefits database. In my query one of the fields in an
    > expression(calculation). I do NOT want this field to show if the employee is
    > not 366 days past the [hire date].
    >
    > how can I do this?? the IIF statements don't seem to be working...but
    > perhaps I am doing it wrong...
    >
    > Thanks in Advance for any help!!!
     
  4. MarieK

    MarieK
    Expand Collapse
    Guest

    Sure...

    IIf ((Date()>"d",366[HireDate])="Yes","[Expr1]","NotValid")

    Thanks in Advance.

    "access user" wrote:

    > can you post your IIF statement?
    >
    > "MarieK" wrote:
    >
    > > I am going crazy trying to figure this out....
    > >
    > > I have a benefits database. In my query one of the fields in an
    > > expression(calculation). I do NOT want this field to show if the employee is
    > > not 366 days past the [hire date].
    > >
    > > how can I do this?? the IIF statements don't seem to be working...but
    > > perhaps I am doing it wrong...
    > >
    > > Thanks in Advance for any help!!!
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    IIF(Date() -[HireDate]>366, [Expr1],Null)
    Should do it

    HTH

    Pieter

    "MarieK" <MarieK@discussions.microsoft.com> wrote in message
    news:3E20698F-1C13-452C-900D-157FF76F0BAB@microsoft.com...
    > Sure...
    >
    > IIf ((Date()>"d",366[HireDate])="Yes","[Expr1]","NotValid")
    >
    > Thanks in Advance.
    >
    > "access user" wrote:
    >
    >> can you post your IIF statement?
    >>
    >> "MarieK" wrote:
    >>
    >> > I am going crazy trying to figure this out....
    >> >
    >> > I have a benefits database. In my query one of the fields in an
    >> > expression(calculation). I do NOT want this field to show if the
    >> > employee is
    >> > not 366 days past the [hire date].
    >> >
    >> > how can I do this?? the IIF statements don't seem to be working...but
    >> > perhaps I am doing it wrong...
    >> >
    >> > Thanks in Advance for any help!!!
     
  6. MarieK

    MarieK
    Expand Collapse
    Guest

    IT WORKED!!
    Thank you sooooo much!

    "Pieter Wijnen" wrote:

    > IIF(Date() -[HireDate]>366, [Expr1],Null)
    > Should do it
    >
    > HTH
    >
    > Pieter
    >
    > "MarieK" <MarieK@discussions.microsoft.com> wrote in message
    > news:3E20698F-1C13-452C-900D-157FF76F0BAB@microsoft.com...
    > > Sure...
    > >
    > > IIf ((Date()>"d",366[HireDate])="Yes","[Expr1]","NotValid")
    > >
    > > Thanks in Advance.
    > >
    > > "access user" wrote:
    > >
    > >> can you post your IIF statement?
    > >>
    > >> "MarieK" wrote:
    > >>
    > >> > I am going crazy trying to figure this out....
    > >> >
    > >> > I have a benefits database. In my query one of the fields in an
    > >> > expression(calculation). I do NOT want this field to show if the
    > >> > employee is
    > >> > not 366 days past the [hire date].
    > >> >
    > >> > how can I do this?? the IIF statements don't seem to be working...but
    > >> > perhaps I am doing it wrong...
    > >> >
    > >> > Thanks in Advance for any help!!!

    >
    >
    >
     

Share This Page