Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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.
    > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page