Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: query errors

  1. #1
    Join Date
    Jan 2004
    Posts
    106

    Unanswered: query errors

    i have created a query to find out how many days late, if any, a book is when it is returned to a library but when i run the query a message appears and i dont know what it means. whats wrong with the query and how do i put it right?

    i have attatched screenshot of the message and the query

  2. #2
    Join Date
    Feb 2004
    Location
    Houston TX
    Posts
    23

    Arrow

    can you re attach the picture, as it dont seem to have gone through.
    Believe Everybody Trust Nobody

  3. #3
    Join Date
    Jan 2004
    Posts
    106
    sorry
    Attached Thumbnails Attached Thumbnails 1.jpg  

  4. #4
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42
    Try using ";" instead of ","

    => DateDiff("d";3/3/2;Now())

  5. #5
    Join Date
    Feb 2004
    Posts
    106
    Try using:

    Days Late: Int(Now()-[LOAN]![Date Due Back])

  6. #6
    Join Date
    Jan 2004
    Posts
    106
    i have tried both ways and the same error keeps coming up

  7. #7
    Join Date
    Feb 2004
    Location
    Binary Universe
    Posts
    57
    Don't use 'Now()' use 'Date()':

    DateDiff("d", [Date Due Back], Date())
    I won't byte... hard!

  8. #8
    Join Date
    Jan 2004
    Posts
    106
    same problem again unfortunatly
    could it be something else in the query that is causing the error?

  9. #9
    Join Date
    Feb 2004
    Location
    Binary Universe
    Posts
    57
    Can you post the SQL string? View ---> SQL copy'n'paste.
    I won't byte... hard!

  10. #10
    Join Date
    Jan 2004
    Posts
    106
    SELECT LOAN.[Date Returned], DateDiff("d",[Date Due Back],Now()) AS [Days Late]
    FROM LOAN
    WHERE (((LOAN.[Date Returned])=[Please Enter Book Number]));

  11. #11
    Join Date
    Feb 2004
    Location
    Binary Universe
    Posts
    57
    wanna get on yahoo messenger?

    I'm 'thebyte2004'
    I won't byte... hard!

  12. #12
    Join Date
    Jan 2004
    Posts
    106
    hav u got msn messenger?
    i can use yahoo if not but prefer msn

  13. #13
    Join Date
    Feb 2004
    Location
    Binary Universe
    Posts
    57
    I only use yahoo. K with you?
    I won't byte... hard!

  14. #14
    Join Date
    Jan 2004
    Posts
    106
    yeah ok

  15. #15
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Access 2002,

    Select DATEDIFF("d", column, date())

    where column is defined as DATE/TIME.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •