Order of table rows switch when added to a sub report (1 Viewer)

[rnorthcott]

Hello everyone!

I am working on updating a reservation database that I created over 10 years ago and am running into a couple client requests I can't figure out. The bulk of the database focuses around entering group reservations for one of Canada's national parks. When saving the group members of each reservation into a table, the order of the group member names match what I entered like this:

However, part of the reservation creation process is to print a receipt for the reservation and any payment received. I have used a sub report to list the visitor names, but the names are in the opposite order than they were entered like this:

I'm sure there is a simple reason for this that I'm missing, but my client would prefer if the order on the report matches the order entered into the table.

He also is asking about separating records in a different report with a line between each record. I haven't been able to find any information about this online and was wondering if anyone had any insight into if this is possible or not.

Thanks everyone for your help!

Raymond (rnorthcott)

 

[isladogs]

Tables have no inherent sort order though may often appear in the order of the PK field.
End users should never work with or even open tables so the table order is irrelevant.

Reports give you a lot of options for both sorting and grouping. This needs to be done in the report design view.
Similarly you can format the report to place a line after each record. Again this is done in design view.

 

[jdraw]

Some thoughts for consideration---but may not be related to your issue.

Records are placed in a table in an order managed by the database management system. Think of storage in a table similar to a bag of marbles. The marbles are in the bag. It isn't until you retrieve the data(marbles) with a query including a sort order that they come out in the order associated with the Sorted By. Without a Sorted By they may come out in any order.

Reports have their own sorting and grouping parameters - and do not use the sort order if the report is based on a query.

 

[rnorthcott]

Definitely some things to consider. Thanks for your input.

 

[rnorthcott]

adding a sort on the report data for the win. I knew it would be relatively simple. I had seen the group and sort options previously, but had to figure out the correct field to sort on and then ensure it is included in the data source. Thanks for the push in the right direction.

 

[Gasman]

Does it really matter that they are shown in the exact order entered?
I would normally sort in alphabetical order when names are involved. Easier to find then.

 

[Pat Hartman]

If you are using an autonumber, sorting by the autonumber will give you a data entry sequence. If that doesn't work, you need to add your own datetime field and sort on that

 

[LarryE]

He also is asking about separating records in a different report with a line between each record. I haven't been able to find any information about this online and was wondering if anyone had any insight into if this is possible or not.

Reports and forms allow you to draw lines. Use design view. Then you can size them and use other options such as dotted, dashed, solid etc. Hold the Shift key down as you draw it with your mouse to make it straight.