Jeff Moden has some articles here on Tally tables.[/url] You could make a tally table with N rows in it (N being a Parameter passed to the query like Scott suggested) and join that table to your original table.