Welcome to SPN

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

Sign Up Now!

Return the Name of a field in a Query.

Discussion in 'Information Technology' started by jon.ingram@comcast.net, Jul 28, 2006.

  1. jon.ingram@comcast.net

    jon.ingram@comcast.net
    Expand Collapse
    Guest

    I have an access data set that essentially looks like this:

    Policy# Status Rec'dDate IssuedDate PlacedDate

    1 Rec'd 12/1/05
    2 Issued 01/01/06 02/01/06
    3 Placed 2/15/06 02/28/06 3/10/06


    The status field is suppose to refresh in a data feed to take the max
    date and return the status, I want to validate this to make sure it is
    working correctly, so I was thinking I could write a query that takes
    the max date and returns what field name it came from. Anyone out
    there ever do anything like this that I might be able to piggy back off
    of? TIA for any help.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Ontario Police Review Arrest Of Sikh Man Whose Turban Wasn't Returned - CTV News Breaking News Jul 16, 2016
    Movies Ashdoc's short movie review---Tanu weds Manu returns Theatre, Movies & Cinema Jun 6, 2015
    Zoroastrianism Parsis pray for return of the scavenger bird Interfaith Dialogues Aug 28, 2013
    Steve Jobs' Return to Apple Business, Lifestyle & Leisure Mar 28, 2013
    Opinion Campaign to reward homeless man who returned diamond engagement ring hits $175,000 - and that total Breaking News Mar 7, 2013

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Just update the field. Use a nested IF statement that says...

    If PlacedDate is not null, then staus equals "Placed" otherwise, if
    IssuedDate is not null, then status equals "Issued", other wise, status
    equals "Rec'd"

    --
    Rick B



    <jon.ingram@comcast.net> wrote in message
    news:1150219463.159147.167520@h76g2000cwa.googlegroups.com...
    >I have an access data set that essentially looks like this:
    >
    > Policy# Status Rec'dDate IssuedDate PlacedDate
    >
    > 1 Rec'd 12/1/05
    > 2 Issued 01/01/06 02/01/06
    > 3 Placed 2/15/06 02/28/06 3/10/06
    >
    >
    > The status field is suppose to refresh in a data feed to take the max
    > date and return the status, I want to validate this to make sure it is
    > working correctly, so I was thinking I could write a query that takes
    > the max date and returns what field name it came from. Anyone out
    > there ever do anything like this that I might be able to piggy back off
    > of? TIA for any help.
    >
     
  4. jon.ingram@comcast.net

    jon.ingram@comcast.net
    Expand Collapse
    Guest

    I wish it were that easy the thing is that there are several more
    status in there that items can move forward and backwards through so I
    need to use some type of max function that spans across the fields.

    Rick B wrote:
    > Just update the field. Use a nested IF statement that says...
    >
    > If PlacedDate is not null, then staus equals "Placed" otherwise, if
    > IssuedDate is not null, then status equals "Issued", other wise, status
    > equals "Rec'd"
    >
    > --
    > Rick B
    >
    >
    >
    > <jon.ingram@comcast.net> wrote in message
    > news:1150219463.159147.167520@h76g2000cwa.googlegroups.com...
    > >I have an access data set that essentially looks like this:
    > >
    > > Policy# Status Rec'dDate IssuedDate PlacedDate
    > >
    > > 1 Rec'd 12/1/05
    > > 2 Issued 01/01/06 02/01/06
    > > 3 Placed 2/15/06 02/28/06 3/10/06
    > >
    > >
    > > The status field is suppose to refresh in a data feed to take the max
    > > date and return the status, I want to validate this to make sure it is
    > > working correctly, so I was thinking I could write a query that takes
    > > the max date and returns what field name it came from. Anyone out
    > > there ever do anything like this that I might be able to piggy back off
    > > of? TIA for any help.
    > >
     

Share This Page