Results 1 to 5 of 5

Thread: Month Criteria

  1. #1
    Join Date
    Oct 2001
    Posts
    10

    Unanswered: Month Criteria

    Hi,
    I'm trying to query a table on the date field to give me all records from April. I thought the criteria should be =Month(4). However, none of the records return. I had this working last month, but it was deleted. Anyone know what I'm doing wrong??
    Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    you need to do a WHERE Month([Field]) = 4 (or in the query builder create a new field Month([Field]) and set criteria to 4)

    Michael

  3. #3
    Join Date
    Oct 2001
    Posts
    10
    thanks but no luck, it's almost like it's not reading the month field as a 4. I've tried a few different ways. I've tried a report with an unbound field that says [date]=month(4) and it just returns all 0's. I've also tried different months, but it gives me the same result.

  4. #4
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    Mhh, if you actually have dates from April it should work.

    This is how it'll look in the query builder (don't be confused by the german captions )
    Attached Thumbnails Attached Thumbnails month.jpg  

  5. #5
    Join Date
    Oct 2001
    Posts
    10
    That's it, I simplified it a little bit. In the criteria for the date field I put =Month([Date])=4. THANKS!!!
    Last edited by Uriarte69; 04-02-02 at 09:58.

Posting Permissions

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