Welcome to SPN

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

Sign Up Now!

Sorting by date

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

Tags:
  1. Andreas

    Andreas
    Expand Collapse
    Guest

    I have a question made from another question. It tells me to which adresses
    two companies have delievered goods the same date the last year. Now I want
    to see the same thing but change the demand that it has to be the same day.
    Instead I want to see which transports that have been made to the sam adress
    with a time span of +- 1 day from any date. How can I do this?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 21 Jul 2006 02:57:01 -0700, Andreas
    <Andreas@discussions.microsoft.com> wrote:

    >I have a question made from another question. It tells me to which adresses
    >two companies have delievered goods the same date the last year. Now I want
    >to see the same thing but change the demand that it has to be the same day.
    >Instead I want to see which transports that have been made to the sam adress
    >with a time span of +- 1 day from any date. How can I do this?


    Add a criterion on the date field such as

    >= DateAdd("d", -1, [Enter Date:]) AND < DateAdd("d", 2, [Enter Date:])


    John W. Vinson[MVP]
     
  4. Andreas

    Andreas
    Expand Collapse
    Guest

    Voila! Perfect! Thanks!

    But I tried everything on a copy of my originial table to be on the safe
    side. I have a lot of questions and forms built up upon "consegna", how can I
    make this change in the original table without affecting this?

    Andreas

    "John Vinson" skrev:

    > On Fri, 21 Jul 2006 02:57:01 -0700, Andreas
    > <Andreas@discussions.microsoft.com> wrote:
    >
    > >I have a question made from another question. It tells me to which adresses
    > >two companies have delievered goods the same date the last year. Now I want
    > >to see the same thing but change the demand that it has to be the same day.
    > >Instead I want to see which transports that have been made to the sam adress
    > >with a time span of +- 1 day from any date. How can I do this?

    >
    > Add a criterion on the date field such as
    >
    > >= DateAdd("d", -1, [Enter Date:]) AND < DateAdd("d", 2, [Enter Date:])

    >
    > John W. Vinson[MVP]
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    <Andreas@discussions.microsoft.com> wrote:

    >Voila! Perfect! Thanks!
    >
    >But I tried everything on a copy of my originial table to be on the safe
    >side. I have a lot of questions and forms built up upon "consegna", how can I
    >make this change in the original table without affecting this?
    >
    >Andreas


    I'm sorry, I have no idea what you're asking here.

    My suggestion did not involve ANY change to ANY table - just a
    criterion in a query to retrieve a date range.


    John W. Vinson[MVP]
     
  6. Andreas

    Andreas
    Expand Collapse
    Guest

    Sorry about that, it was another question I got answered.

    When I write the code you gave me I get an error message (Unfortunately in
    italian but I do my best to translate)

    "Errore di sintassi nell espressione" (Error in the syntax(syntax is a
    professional guess) of the expression)

    "Operando o operatore mancante, carattere o virgola non valida oppure testo
    immesso non racchiuso tra virgolette" (Operator or operation is missing,
    character or comma is not valid otherwise ... etc)

    I understand it is not easy for you :) but I would really appreciate your
    help


    I have done exactly as you described otherwise (I think...) I write my date
    as yyyy-mm-dd if that will help.

    "John Vinson" skrev:

    > On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    > <Andreas@discussions.microsoft.com> wrote:
    >
    > >Voila! Perfect! Thanks!
    > >
    > >But I tried everything on a copy of my originial table to be on the safe
    > >side. I have a lot of questions and forms built up upon "consegna", how can I
    > >make this change in the original table without affecting this?
    > >
    > >Andreas

    >
    > I'm sorry, I have no idea what you're asking here.
    >
    > My suggestion did not involve ANY change to ANY table - just a
    > criterion in a query to retrieve a date range.
    >
    >
    > John W. Vinson[MVP]
    >
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Use ';' instead of ',' in a Query, Form or Report (GUI)
    The GUI uses the Windows (Regional settings) List seperator
    ie
    = DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

    Pieter

    "Andreas" <Andreas@discussions.microsoft.com> wrote in message
    news:CD04051A-6FBF-41FC-A1B0-076DBF982877@microsoft.com...
    > Sorry about that, it was another question I got answered.
    >
    > When I write the code you gave me I get an error message (Unfortunately in
    > italian but I do my best to translate)
    >
    > "Errore di sintassi nell espressione" (Error in the syntax(syntax is a
    > professional guess) of the expression)
    >
    > "Operando o operatore mancante, carattere o virgola non valida oppure
    > testo
    > immesso non racchiuso tra virgolette" (Operator or operation is missing,
    > character or comma is not valid otherwise ... etc)
    >
    > I understand it is not easy for you :) but I would really appreciate your
    > help
    >
    >
    > I have done exactly as you described otherwise (I think...) I write my
    > date
    > as yyyy-mm-dd if that will help.
    >
    > "John Vinson" skrev:
    >
    >> On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    >> <Andreas@discussions.microsoft.com> wrote:
    >>
    >> >Voila! Perfect! Thanks!
    >> >
    >> >But I tried everything on a copy of my originial table to be on the safe
    >> >side. I have a lot of questions and forms built up upon "consegna", how
    >> >can I
    >> >make this change in the original table without affecting this?
    >> >
    >> >Andreas

    >>
    >> I'm sorry, I have no idea what you're asking here.
    >>
    >> My suggestion did not involve ANY change to ANY table - just a
    >> criterion in a query to retrieve a date range.
    >>
    >>
    >> John W. Vinson[MVP]
    >>
     
  8. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Use ';' instead of ',' in a Query, Form or Report (GUI)
    The GUI uses the Windows (Regional settings) List seperator
    ie
    = DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])

    Pieter

    "Andreas" <Andreas@discussions.microsoft.com> wrote in message
    news:CD04051A-6FBF-41FC-A1B0-076DBF982877@microsoft.com...
    > Sorry about that, it was another question I got answered.
    >
    > When I write the code you gave me I get an error message (Unfortunately in
    > italian but I do my best to translate)
    >
    > "Errore di sintassi nell espressione" (Error in the syntax(syntax is a
    > professional guess) of the expression)
    >
    > "Operando o operatore mancante, carattere o virgola non valida oppure
    > testo
    > immesso non racchiuso tra virgolette" (Operator or operation is missing,
    > character or comma is not valid otherwise ... etc)
    >
    > I understand it is not easy for you :) but I would really appreciate your
    > help
    >
    >
    > I have done exactly as you described otherwise (I think...) I write my
    > date
    > as yyyy-mm-dd if that will help.
    >
    > "John Vinson" skrev:
    >
    >> On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    >> <Andreas@discussions.microsoft.com> wrote:
    >>
    >> >Voila! Perfect! Thanks!
    >> >
    >> >But I tried everything on a copy of my originial table to be on the safe
    >> >side. I have a lot of questions and forms built up upon "consegna", how
    >> >can I
    >> >make this change in the original table without affecting this?
    >> >
    >> >Andreas

    >>
    >> I'm sorry, I have no idea what you're asking here.
    >>
    >> My suggestion did not involve ANY change to ANY table - just a
    >> criterion in a query to retrieve a date range.
    >>
    >>
    >> John W. Vinson[MVP]
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  9. Andreas

    Andreas
    Expand Collapse
    Guest

    I have tried that but then it says

    "Syntax error in the expression"

    "It is not possible to make a operation without an operator" (or something
    like that)

    Possible to solve somehow?

    /Andreas



    "Pieter Wijnen" skrev:

    > Use ';' instead of ',' in a Query, Form or Report (GUI)
    > The GUI uses the Windows (Regional settings) List seperator
    > ie
    > = DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])
    >
    > Pieter
    >
    > "Andreas" <Andreas@discussions.microsoft.com> wrote in message
    > news:CD04051A-6FBF-41FC-A1B0-076DBF982877@microsoft.com...
    > > Sorry about that, it was another question I got answered.
    > >
    > > When I write the code you gave me I get an error message (Unfortunately in
    > > italian but I do my best to translate)
    > >
    > > "Errore di sintassi nell espressione" (Error in the syntax(syntax is a
    > > professional guess) of the expression)
    > >
    > > "Operando o operatore mancante, carattere o virgola non valida oppure
    > > testo
    > > immesso non racchiuso tra virgolette" (Operator or operation is missing,
    > > character or comma is not valid otherwise ... etc)
    > >
    > > I understand it is not easy for you :) but I would really appreciate your
    > > help
    > >
    > >
    > > I have done exactly as you described otherwise (I think...) I write my
    > > date
    > > as yyyy-mm-dd if that will help.
    > >
    > > "John Vinson" skrev:
    > >
    > >> On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    > >> <Andreas@discussions.microsoft.com> wrote:
    > >>
    > >> >Voila! Perfect! Thanks!
    > >> >
    > >> >But I tried everything on a copy of my originial table to be on the safe
    > >> >side. I have a lot of questions and forms built up upon "consegna", how
    > >> >can I
    > >> >make this change in the original table without affecting this?
    > >> >
    > >> >Andreas
    > >>
    > >> I'm sorry, I have no idea what you're asking here.
    > >>
    > >> My suggestion did not involve ANY change to ANY table - just a
    > >> criterion in a query to retrieve a date range.
    > >>
    > >>
    > >> John W. Vinson[MVP]
    > >>

    >
    >
    >
    > --
    > ----------------------------------------
    > I am using the free version of SPAMfighter for private users.
    > It has removed 4367 spam emails to date.
    > Paying users do not have this message in their emails.
    > Get the free SPAMfighter here: http://www.spamfighter.com/len
    >
    >
    >
     
  10. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    missed the seccond ',' (to quick again)

    = DateAdd("d"; -1; [Enter Date:]) AND < DateAdd("d"; 2; [Enter Date:])

    sorry about that

    Pieter

    "Pieter Wijnen"
    <it.isi.llegal.to.send.unsollicited.mail.wijnen.nospam.please@online.replace.with.norway>
    wrote in message news:uSCNSDWsGHA.3832@TK2MSFTNGP06.phx.gbl...
    > Use ';' instead of ',' in a Query, Form or Report (GUI)
    > The GUI uses the Windows (Regional settings) List seperator
    > ie
    > = DateAdd("d"; -1, [Enter Date:]) AND < DateAdd("d"; 2, [Enter Date:])
    >
    > Pieter
    >
    > "Andreas" <Andreas@discussions.microsoft.com> wrote in message
    > news:CD04051A-6FBF-41FC-A1B0-076DBF982877@microsoft.com...
    >> Sorry about that, it was another question I got answered.
    >>
    >> When I write the code you gave me I get an error message (Unfortunately
    >> in
    >> italian but I do my best to translate)
    >>
    >> "Errore di sintassi nell espressione" (Error in the syntax(syntax is a
    >> professional guess) of the expression)
    >>
    >> "Operando o operatore mancante, carattere o virgola non valida oppure
    >> testo
    >> immesso non racchiuso tra virgolette" (Operator or operation is missing,
    >> character or comma is not valid otherwise ... etc)
    >>
    >> I understand it is not easy for you :) but I would really appreciate
    >> your
    >> help
    >>
    >>
    >> I have done exactly as you described otherwise (I think...) I write my
    >> date
    >> as yyyy-mm-dd if that will help.
    >>
    >> "John Vinson" skrev:
    >>
    >>> On Wed, 26 Jul 2006 08:00:01 -0700, Andreas
    >>> <Andreas@discussions.microsoft.com> wrote:
    >>>
    >>> >Voila! Perfect! Thanks!
    >>> >
    >>> >But I tried everything on a copy of my originial table to be on the
    >>> >safe
    >>> >side. I have a lot of questions and forms built up upon "consegna", how
    >>> >can I
    >>> >make this change in the original table without affecting this?
    >>> >
    >>> >Andreas
    >>>
    >>> I'm sorry, I have no idea what you're asking here.
    >>>
    >>> My suggestion did not involve ANY change to ANY table - just a
    >>> criterion in a query to retrieve a date range.
    >>>
    >>>
    >>> John W. Vinson[MVP]
    >>>

    >
    >


    --------------------------------------------------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4382 spam emails to date.
    Paying users do not have this message in their emails.
    Try SPAMfighter for free now!
     

Share This Page