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.
Printable View
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.
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]