Append query using paramters

[Michael Curry]

Hi,

I would like to create an append query which would use parameters for
the data to be appended.

I would like the query to ask for a Start number, e.g 1 and a End
number, eg 25. In this case the append query would then append the
numbers 1 through to 25 inclusive to the table.

I thought I could enter the following in the criteria:

Between [Enter Start No.] AND [Enter End No.]

but this did not work.


Any ideas?


Thanks

Michael

 

[Duane Hookom]

Create a table of all numbers from 1 to your maximum and use it in your
append query.