Report detail records not in order

[Guest]

hell
i have 2 tables in 1 to many relation and a form with subform to enter the details

When i make a report the details(from the many side) are not printed in the order in which they were entered but in a descending order,that is the last detail record prints first and the first detail record the last
there is no sorting grouping in the Report also
the fields in the detail are Description and remarks only(both are text fields

How to ensure that the details are printed as entere

 

[Duane Hookom]

There is no order to records in an Access table. You must provide an order
for the records. In a report, use the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP

hello
i have 2 tables in 1 to many relation and a form with subform to enter the details.

When i make a report the details(from the many side) are not printed in

the order in which they were entered but in a descending order,that is the
last detail record prints first and the first detail record the last.

 

[Allen Browne]

Conceptually, a table is like a bucket that holds the records. If you
provide no way to define the order in which they were added, then the order
is undefined, as you found on your report.

If your related table has an AutoNumber field, you can probably use that as
a guide to the order the records were added. Open the report in Design view,
and add the name of the AutoNumber field to the Sorting And Grouping dialog
(View menu) to specify the order you want to items printed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

i have 2 tables in 1 to many relation and a form with subform to enter the details.

When i make a report the details(from the many side) are not printed in

the order in which they were entered but in a descending order,that is the
last detail record prints first and the first detail record the last.

 

[Guest]

hello
Thanks for the info.I tried Allen's suggestion but
One thing i notice is that if i put the Autonumber field it keeps on incrementing across all the reports.
What i mean is For ReportNo: 1 the detail records for this shows up as
ReportNo1...LineNo=1(autonumberfield)
ReportNo1...lineNo=2(autonumberfield)

Then when i go to Report No:2 the detail records shaow as
ReportNo2...LineNo=3(autonumberfield)
ReportNo2...lineNo=4(autonumberfield)

How can i start the LineNo for Report to start again from 1 and not continue as it does in an auto number field ?
like ReportNo2...LineNo=1
etc
ReportNo3...LineNo=1

TIA
Joanna


----- Duane Hookom wrote: -----

There is no order to records in an Access table. You must provide an order
for the records. In a report, use the Sorting and Grouping dialog.

--
Duane Hookom
MS Access MVP

hello
i have 2 tables in 1 to many relation and a form with subform to enter the details.

the order in which they were entered but in a descending order,that is the
last detail record prints first and the first detail record the last.

 

[Guest]

hello
Thanks for the info.
One thing i notice is that if i put the Autonumber field it keeps on incrementing across all the reports.
What i mean is For ReportNo: 1 the detail records for this shows up as
ReportNo1...LineNo=1(autonumberfield)
ReportNo1...lineNo=2(autonumberfield)

Then when i go to Report No:2 the detail records shaow as
ReportNo2...LineNo=3(autonumberfield)
ReportNo2...lineNo=4(autonumberfield)

How can i start the LineNo for Report to start again from 1 and not continue as it does in an auto number field ?
like ReportNo2...LineNo=1
etc
ReportNo3...LineNo=1

TIA
Joanna


----- Allen Browne wrote: -----

Conceptually, a table is like a bucket that holds the records. If you
provide no way to define the order in which they were added, then the order
is undefined, as you found on your report.

If your related table has an AutoNumber field, you can probably use that as
a guide to the order the records were added. Open the report in Design view,
and add the name of the AutoNumber field to the Sorting And Grouping dialog
(View menu) to specify the order you want to items printed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

the order in which they were entered but in a descending order,that is the
last detail record prints first and the first detail record the last.

 

[Allen Browne]

Joanna, what does the AutoNumber have to do with reports?
The table gets a number for each record.
Does the table exist only for reports or something?
Normally this gives you a unique identifier for each record in the table.

In any case, if it gives you a way to order the records, doesn't that work?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

hello
Thanks for the info.
One thing i notice is that if i put the Autonumber field it keeps on

incrementing across all the reports.

What i mean is For ReportNo: 1 the detail records for this shows up as
ReportNo1...LineNo=1(autonumberfield)
ReportNo1...lineNo=2(autonumberfield)

Then when i go to Report No:2 the detail records shaow as
ReportNo2...LineNo=3(autonumberfield)
ReportNo2...lineNo=4(autonumberfield)

How can i start the LineNo for Report to start again from 1 and not

continue as it does in an auto number field ?

 

[Guest]

Yes ! Allen ! your are quite right and it doesn't matter as long as it works
My thought was that i could call it Serial Number or Line Number and display it to the user,but with this approach i cant since the line number will different,like starting from 15(say) as the number of reports grow
So i guess i'll have to drop the idea of displaying a line number
Thanks for your hel
Joann


----- Allen Browne wrote: ----

Joanna, what does the AutoNumber have to do with reports
The table gets a number for each record
Does the table exist only for reports or something
Normally this gives you a unique identifier for each record in the table

In any case, if it gives you a way to order the records, doesn't that work

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.htm
Reply to group, rather than allenbrowne at mvps dot org

hell
Thanks for the info
One thing i notice is that if i put the Autonumber field it keeps o

incrementing across all the reports

What i mean is For ReportNo: 1 the detail records for this shows up a
ReportNo1...LineNo=1(autonumberfield
ReportNo1...lineNo=2(autonumberfield

continue as it does in an auto number field

 

[Allen Browne]

Now your report is sorting correctly, would you like another trick that
shows the line number on the report?

1. Open the report in design view.

2. Add a text box to the detail section.

3. Right-click it and choose Properties.

4. Set the Control Source property to:
=1

5. Set the Running Sum property to:
Over Group

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Yes ! Allen ! your are quite right and it doesn't matter as long as it works.
My thought was that i could call it Serial Number or Line Number and

display it to the user,but with this approach i cant since the line number
will different,like starting from 15(say) as the number of reports grow.

 

[Guest]

Allen
What would i do without your help
Great trick or shall i say ti
thanks a lo
Joanna