Table and Printing Problems

[Guest]

We have table that the first thing you enter is a number so that the table
stays in order like 1-2-3-ect. and we pull information from that table and
print a permit that the report is set up to print on our permit paper but
know it is throwing the information to diffrent pages, it used to be that to
print something if you were on record 5 then you printed page 5 for that
information but it is throwing the information all over the pages and I like
not for record 5 it is in page 2. If anyone has some information on how I
can correct this please let me know.

Thank You,
Anthony Risteff

 

[John Vinson]

We have table that the first thing you enter is a number so that the table
stays in order like 1-2-3-ect.

There's your first mistake. A Table is an unordered "heap" of data. If
you want data in a particular sequence, the best way to do so is to
create a Query with a sort clause, and/or a Report with its sorting
and grouping parameter set.

and we pull information from that table and
print a permit that the report is set up to print on our permit paper but
know it is throwing the information to diffrent pages, it used to be that to
print something if you were on record 5 then you printed page 5 for that
information but it is throwing the information all over the pages and I like
not for record 5 it is in page 2. If anyone has some information on how I
can correct this please let me know.

Since Access has no record numbers, the question as asked cannot be
answered.

Use the "Sorting and Grouping" feature of the report to sort the data
however you like. I'm wondering - do you print out all of the records
in the entire table whenever you print a report? That would be most
unusual!

John W. Vinson[MVP]