Order of Detail Records on a Report

[Guest]

I have a typical report that is made up of grouped header and detail records.
I need the records in the detail to show up on the report in the same order
they were entered on the form. I have no sorting or grouping on any of the
fields in the detail section. I can't find any rhyme or reason to how the
detail is listed now. Any suggestions?

 

[Shaun Beane]

your detail is sorted by whatever field you grouped on ... then to the best
of my knowledge, it's however the data is stored in the database.

Shaun Beane

 

[Tom Lake]

I have a typical report that is made up of grouped header and detail
records.
I need the records in the detail to show up on the report in the same
order
they were entered on the form. I have no sorting or grouping on any of
the
fields in the detail section. I can't find any rhyme or reason to how the
detail is listed now. Any suggestions?

What I do is to include a hidden field on the input form with default value
Now().
This is not a Tab Stop and not active.
I then sort on that in the report detail and it gives the chronological
order of input.

Tom Lake

 

[Guest]

Thanks. Worked like a charm!!

What I do is to include a hidden field on the input form with default value
Now().
This is not a Tab Stop and not active.
I then sort on that in the report detail and it gives the chronological
order of input.

Tom Lake