incr

-- incr (incremental number from 0 to 49)
-- MS ACCESS JET
-- dummy table: NULL value
SELECT n1.n+n2.n*10+n3.n*100 AS n
FROM
  (SELECT 0 AS n
   FROM dummy
   UNION SELECT 1 AS n
   FROM dummy
   UNION SELECT 2 AS n
   FROM dummy
   UNION SELECT 3 AS n
   FROM dummy
   UNION SELECT 4 AS n
   FROM dummy
   UNION SELECT 5 AS n
   FROM dummy
   UNION SELECT 6 AS n
   FROM dummy
   UNION SELECT 7 AS n
   FROM dummy
   UNION SELECT 8 AS n
   FROM dummy
   UNION SELECT 9 AS n
   FROM dummy) AS n1,

  (SELECT 0 AS n
   FROM dummy
   UNION SELECT 1 AS n
   FROM dummy
   UNION SELECT 2 AS n
   FROM dummy
   UNION SELECT 3 AS n
   FROM dummy
   UNION SELECT 4 AS n
   FROM dummy
   UNION SELECT 5 AS n
   FROM dummy
   UNION SELECT 6 AS n
   FROM dummy
   UNION SELECT 7 AS n
   FROM dummy
   UNION SELECT 8 AS n
   FROM dummy
   UNION SELECT 9 AS n
   FROM dummy) AS n2,

  (SELECT 0 AS n
   FROM dummy
   UNION SELECT 1 AS n
   FROM dummy
   UNION SELECT 2 AS n
   FROM dummy
   UNION SELECT 3 AS n
   FROM dummy
   UNION SELECT 4 AS n
   FROM dummy
   UNION SELECT 5 AS n
   FROM dummy
   UNION SELECT 6 AS n
   FROM dummy
   UNION SELECT 7 AS n
   FROM dummy
   UNION SELECT 8 AS n
   FROM dummy
   UNION SELECT 9 AS n
   FROM dummy) AS n3
WHERE ((([n1].[n]+[n2].[n]*10+[n3].[n]*100)<=49));