Results 1 to 4 of 4
  1. 01-16-2012, 01:50 PM #1
    scoughlan
    scoughlan is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Location
    London
    Posts
    13

    Query criterion for today and the future


    Hi. I'm currently using the filter criterion ">Date()" which does as MS says: Returns records that will take place after today. I'm hoping someone will know how to modify this to include the current date, i.e. today, and after today. Thanks for any help in advance.
    Reply With Quote Reply With Quote
  2. 01-16-2012, 02:09 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    How about

    >=Date()
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 01-16-2012, 04:44 PM #3
    scoughlan
    scoughlan is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012
    Location
    London
    Posts
    13
    That simple? Why didn't I think of that?!!? Thanks very much.
    Last edited by scoughlan; 01-16-2012 at 04:45 PM. Reason: Forgot to say thank you
    Reply With Quote Reply With Quote
  4. 01-16-2012, 07:28 PM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Show report for today only
    By cooper in forum Reports
    Replies: 6
    Last Post: 09-06-2011, 12:46 PM
  2. Query to display ONLY entries from today
    By Juan4412 in forum Queries
    Replies: 9
    Last Post: 01-15-2011, 05:34 PM
  3. Future date parameter
    By normie in forum Queries
    Replies: 10
    Last Post: 08-12-2010, 09:38 PM
  4. Question about the future of Access
    By kantell in forum Access
    Replies: 0
    Last Post: 11-04-2008, 11:43 AM
  5. query date that is five years older than today
    By cpsummer in forum Queries
    Replies: 2
    Last Post: 09-26-2007, 02:31 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