Pozition of records

[Florin]

Hi,

how can I print report with pozition of records identical with pozition on
the main table.
The record source of my reports is a query with a lot of table.

Thanks

 

[Douglas J. Steele]

You should never make any assumptions about the order of records in a table
(or query): tables are "sacks of data", where the records can be wherever
Access feels like putting them.

If the order of the records is important, you need to ensure that the table
includes sufficient information to allow you to do an ORDER BY to get the
records in the desired order. Once you've got that, you need to ensure that
the same fields are included in the report's Sorting and Grouping dialog,
since reports do not respect the order of records in the underlying
recordsource.

 

[RBear3]

The order of records in a table is not important. Records will not reliably
stay in the same order in your table.

If the order is important, you need to add a new field to your table and
enter something that can be used for sorting.

 

[Florin]

I very clear

Thanks
Florin

The order of records in a table is not important. Records will not reliably
stay in the same order in your table.

If the order is important, you need to add a new field to your table and
enter something that can be used for sorting.

--
Hope that helps!

RBear3
.