Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Cape Town
    Posts
    8

    Unanswered: no records showing, please help me check syntax

    i have created a query to check for records between two dates.

    its brings up no records but there are in the table

    I have a jobDate field in the table.

    in the query for criteria in jobdate i have

    Between date() and date()-"6"

    i am checking for all records between now and 6 days ago.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    272
    It works for me.

    Is your jobDate a Date/Time-field? Are there other conditions in your query that may prevent the data from showing?

  3. #3
    Join Date
    Sep 2003
    Location
    Cape Town
    Posts
    8
    i do have a field which checks to make sure the product has not been returned, i just check to see if it is null. i have checked without, i have tried to change the field in the table to a text and datetime, i must be overlooking something.

    thanks for the reply

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Between date() and date()-"6" ??

    Why do you use Apostroph, just use

    Between Date() And Date()-6

  5. #5
    Join Date
    Nov 2002
    Posts
    272
    Quote Originally Posted by hammbakka
    Between date() and date()-"6" ??

    Why do you use Apostroph, just use

    Between Date() And Date()-6
    I tried both, and both work for me. (Access 2000)

  6. #6
    Join Date
    Sep 2003
    Location
    Cape Town
    Posts
    8
    sorted it out, the field had to be set as short date.

    thanks for the help

Posting Permissions

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