Welcome to SPN

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

Sign Up Now!

critiera

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

Tags:
  1. Chey

    Chey
    Expand Collapse
    Guest

    I have a field called date return in a query. How do I only show the dates
    that have already passed? For example.
    7/14/06
    7/20/06
    7/29/06
    8/20/06

    Only 2 of the dates should show. Once 7/29 has passed then that one will
    show.
    I tried >[Date Return] I just don't know where to put this. Should I
    create a new field in the query?

    Thanks
    Chey
     
  2. Biz Enhancer

    Biz Enhancer
    Expand Collapse
    Guest

    Hi Chey,

    Try " < Date() " in the criteria for the [Date Return] field in the query

    Hope it helps.
    Regards,
    Nick


    "Chey" wrote:

    > I have a field called date return in a query. How do I only show the dates
    > that have already passed? For example.
    > 7/14/06
    > 7/20/06
    > 7/29/06
    > 8/20/06
    >
    > Only 2 of the dates should show. Once 7/29 has passed then that one will
    > show.
    > I tried >[Date Return] I just don't know where to put this. Should I
    > create a new field in the query?
    >
    > Thanks
    > Chey
     
  3. Chey

    Chey
    Expand Collapse
    Guest

    I did that but I want it to show after the traveler has returned from there
    trip. So that is why I was trying to do it for [Date Return]

    "Biz Enhancer" wrote:

    > Hi Chey,
    >
    > Try " < Date() " in the criteria for the [Date Return] field in the query
    >
    > Hope it helps.
    > Regards,
    > Nick
    >
    >
    > "Chey" wrote:
    >
    > > I have a field called date return in a query. How do I only show the dates
    > > that have already passed? For example.
    > > 7/14/06
    > > 7/20/06
    > > 7/29/06
    > > 8/20/06
    > >
    > > Only 2 of the dates should show. Once 7/29 has passed then that one will
    > > show.
    > > I tried >[Date Return] I just don't know where to put this. Should I
    > > create a new field in the query?
    > >
    > > Thanks
    > > Chey
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 25 Jul 2006 16:28:02 -0700, Chey
    <Chey@discussions.microsoft.com> wrote:

    >I did that but I want it to show after the traveler has returned from there
    >trip. So that is why I was trying to do it for [Date Return]
    >
    >"Biz Enhancer" wrote:
    >
    >> Hi Chey,
    >>
    >> Try " < Date() " in the criteria for the [Date Return] field in the query


    Ummm... that's what he said to do.

    Create a Query based on your Table.
    Put < Date() on the Criteria box underneath the [Date Return] field.
    It will now show you all completed trips, i.e. those with a DateReturn
    value prior to today's date.

    Is that not what you're seeing?

    John W. Vinson[MVP]
     

Share This Page