I am trying to do the following SQL statement for a report form. Basically I am trying to choose a bunch of Index table records that _almost_ match records in my RptIndex table on a tolerance of +/-.1. Eventually I want to replace .1 with a variable from a form that will prompt at runtime. But Access doesnt seem to like the following. It tells me that the AND is missing.
SELECT Index.Index1 FROM (RptIndex INNER JOIN [Index] ON ( Index.Index1 Between (RptIndex.Index1-.1) AND (RptIndex.Index1+.1) ));
Both Index & RptIndex have fields called Index1.