Results 1 to 3 of 3
  1. #1
    Ushera is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    5

    a simple "display date " query

    Hello,
    i am new to this forum, i have some basics about databases but i really have a problem with this simple query (i hope it's simple!!)
    I want to create a query that will display one week in advance the "end date " of a student internship. In the table i have a field named "end date".
    I heard I have to use combos, but i am not familiar with those.
    The database is not for use in a website.
    Please somebody give some advices/guidance.


    Thanks a lot..........

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    So if i am correct you have a date and you want to display 1 week ahead of that date. If so you need to use the DateAdd function as follows:

    DateAdd("ww", 1, [End Date])

  3. #3
    Ushera is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    5
    Thanx a lot for your reply!!

    I think I solved it!
    Actually I need to display all the dates between today and the following 7 days
    I used sth like this and it worked

    enddate<DateAdd('d', 7, (enter today's date))

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

Similar Threads

  1. Access 2003 Date() Function returns "#Name?"
    By smartel@soprema.ca in forum Programming
    Replies: 5
    Last Post: 01-18-2012, 05:52 AM
  2. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  3. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  4. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM
  5. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM

Tags for this Thread

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