Results 1 to 2 of 2
  1. #1
    TheSpecialist is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2015
    Location
    Georgia
    Posts
    47

    Creating parameters Access for Dates 2 days before and 1 day after the original date

    Good afternoon,



    I have a parameter that if I enter a number for example the number 1. Every date(s) thats in my databse that number 1 fell on the dates show along with the number 1 becomes that was my parameter. I want to be able to see by creating another parameter not only the date that came from the number 1 I entered but I want to see the dates for 2 days before and 1 the after the original date that is associated with the number 1 because I want to see everything in my database as it relates to my information. Please assist me

    Thank you,

    Erika Perry

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the form: frmRpt
    txtBoxSTartDate has the date entered


    select * from table where [date] between DateAdd("d",-2,forms!frmRpt!txtBoxSTartDate) and DateAdd("d",1,forms!frmRpt!txtBoxSTartDate)

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

Similar Threads

  1. Replies: 1
    Last Post: 05-14-2016, 10:39 PM
  2. Replies: 2
    Last Post: 04-10-2015, 03:51 AM
  3. Replies: 2
    Last Post: 05-19-2013, 06:03 AM
  4. Select Dates between days and two days ago?
    By rstonehouse in forum Queries
    Replies: 4
    Last Post: 08-18-2010, 02:13 AM
  5. Replies: 0
    Last Post: 07-27-2009, 07:51 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