Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: BETWEEN .... AND operator produced two records

    I can't figure out why the query only give me just two records, the first and last records.
    I used BETWEEN .... AND operator to define my date range.

    This is my query
    SELECT tblRGAmo.Date, tblRGAmo.Apple, tblRGAmo.Other, tblRGAmo.[Apple %], tblRGAmo.[Other %]
    FROM tblRGAmo
    WHERE (((tblRGAmo.Date) Between [Forms]![frmDateRangeCht]![txtBeginningMonth] And [Forms]![frmDateRangeCht]![txtEndingMonth]));

    The dates in the date range do exist in the table.

    Anyone have an idea?

    Thanks!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tried displaying the real query in your form - copy and paste it into an access query to see if you receive the same results ?

  3. #3
    Join Date
    May 2002
    Posts
    395
    Thanks!
    It's working now.

    Have a Great Weekend!

Posting Permissions

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