Results 1 to 2 of 2

Thread: Query output is blank

  1. #1
    Join Date
    May 2016
    Posts
    1

    Query output is blank

    hi,

    I am running query

    SELECT field1, field2 FROM tablename WHERE field1 Between field1 = [Start number] AND field1 = [End number];

    it is executing but OUTPUT is blank.

  2. #2
    Join Date
    Nov 2020
    Posts
    35
    WHERE clause makes no sense. Essentially, it is trying to find records WHERE field1 BETWEEN True/False AND True/False. Perhaps you want: WHERE field1 BETWEEN [Start number] AND [End number]

Posting Permissions

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