Results 1 to 3 of 3
  1. #1
    Ellitivity is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    2

    Help

    I'm new to Access and i need to make a simple data base on a small town library. I need to create a query that shows overdue books, and as you should know microsoft help is basicly useless. Can someone please help!

  2. #2
    Ellitivity is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    2
    Quote Originally Posted by Ellitivity View Post
    I'm new to Access and i need to make a simple data base on a small town library. I need to create a query that shows overdue books, and as you should know microsoft help is basicly useless. Can someone please help!
    i'm told that the code that you put under the 'due back date' column is: <=date()
    but it doesnt work
    can some please help?

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you are talking about in the Query Builder then having what you posted in the Criteria row should probably work.

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

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