Results 1 to 3 of 3
  1. 06-04-2009, 01:54 PM #1
    techexpressinc's Avatar
    techexpressinc
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    less than 180 days old

    I want records less than 180 days old. I coded it up as
    <Date()-180

    But it does not work.
    Any ideas for improvement?

    A picture of the query is attached to look at.
    Thanks


    Russ
    rneuman at scaninc.org
    Reply With Quote Reply With Quote
  2. 06-04-2009, 02:09 PM #2
    techexpressinc's Avatar
    techexpressinc
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151
    Never mind - Duh - the < should be >
    Reply With Quote Reply With Quote
  3. 06-04-2009, 04:29 PM #3
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I sense some learning taking place here. Feels good doesn't it? Time to mark the thread as solved? It is a Thread tool.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. 90 days in the pass - Date help wanted
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 01-26-2009, 07:13 AM
  2. Default Value in table = Field plus 3 days
    By AmyLynnHill in forum Access
    Replies: 1
    Last Post: 08-03-2008, 01:58 AM
  3. Total no of days in a month
    By wasim_sono in forum Forms
    Replies: 4
    Last Post: 10-15-2006, 01:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums