Results 1 to 2 of 2
  1. #1
    pgmclement is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    2

    How do I make a query criteria to give me On Or Before a date

    How do I make a query criteria to give me On Or Before a date
    E.g <=#31/12/2015#
    I want to be able to type in my own date.
    I dont want to use Access Report, Query or Table inbuilt design that gives you
    the option of right clicking the date and then go to date filter and select 'before'.
    I want whenever I call up the report, it should ask for that parameter and then I type in
    my own date. More so, I dont want to use 'between'.
    Thanks

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can we make this criteria in a query?
    By ariansman in forum Queries
    Replies: 1
    Last Post: 12-15-2014, 12:16 AM
  2. How to make a query ask for criteria?
    By hesca in forum Queries
    Replies: 1
    Last Post: 10-04-2012, 10:10 AM
  3. Make query print YES or NO for certain Criteria
    By taimysho0 in forum Queries
    Replies: 3
    Last Post: 12-12-2011, 01:33 PM
  4. Replies: 1
    Last Post: 12-12-2011, 06:32 AM
  5. Replies: 1
    Last Post: 07-13-2011, 11:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums