J
Jonesy
We are considering archiving our records into Access. I've already made a
test table, then run a query to extract 5 fields. It is intended that people
will query the table by selecting one record, then displaying say the next
500 records and not necessarily from the first record. I'd like to do this
via a query so that it can be exported to Excel. Also, can I create a box on
a form so the user can select how many records he/she would like to see,
before the query is run?
Thanks in advance, A Beginner.
Example...
fld1 fld2 fld3 fld4 AutoNumb
1828585 J28676 0726 06/06/2007 1
1390784 12390A 0862 06/06/2007 2
test table, then run a query to extract 5 fields. It is intended that people
will query the table by selecting one record, then displaying say the next
500 records and not necessarily from the first record. I'd like to do this
via a query so that it can be exported to Excel. Also, can I create a box on
a form so the user can select how many records he/she would like to see,
before the query is run?
Thanks in advance, A Beginner.
Example...
fld1 fld2 fld3 fld4 AutoNumb
1828585 J28676 0726 06/06/2007 1
1390784 12390A 0862 06/06/2007 2