Welcome to SPN

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

Sign Up Now!

Date queries

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

Tags:
  1. MaggieMay

    MaggieMay
    Expand Collapse
    Guest

    I want to create a query that will only return the results if the main date
    (date1) does not either equal date2 and date3.

    Any suggestions on how to do this?
    --
    May MacKenzie
    Administrative Assistant
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    In SQL

    Select * From TableName
    Where Date1 <> Date2 And Date1 <> Date3

    Or, in the query in the criteria section, write Under Date2 and Date3

    <> Date1

    --
    Good Luck
    BS"D


    "MaggieMay" wrote:

    > I want to create a query that will only return the results if the main date
    > (date1) does not either equal date2 and date3.
    >
    > Any suggestions on how to do this?
    > --
    > May MacKenzie
    > Administrative Assistant
     

Share This Page