Order of Detail Records on a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Sarah0824 said:
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?
Click to expand...

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
 
Thanks. Worked like a charm!!

Tom Lake said:
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
Click to expand...
 
Back
Top