1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Access Queries : Criteria

Discussion in 'Other PC Software' started by GSlick, 2006/01/16.

  1. 2006/01/16
    GSlick

    GSlick Inactive Thread Starter

    Joined:
    2005/01/16
    Messages:
    11
    Likes Received:
    0
    When creating queries in Microsoft Access, what needs to go in the criteria when you want to search for something over/more than the value?. E.g. Dates after 17/07/85 or numbers over a certain value.
     
    GSlick,
    #1
  2. 2006/01/16
    bluzkat

    bluzkat Inactive

    Joined:
    2002/04/02
    Messages:
    626
    Likes Received:
    0
    Generally... you can use a 'greater than' sign ">" (without the quotes), but the answer is probably not that simple. I would suggest that you go into the Access 'Help' files and search for 'queries' and 'criteria'. You will find a lot of information about the different types of queries available in Access and how to use them. HTH

    B :cool:
     
    bluzkat,
    #2


  3. to hide this advert.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...