If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing Database Records in Specific Order
I have a delivery service which is composed of various routes. The
route stops have been defined in database tables. Route sheets are printed based upon these tables. However, I need to have the stops print in an particular order/sequence; i.e. first stop, second stop, etc. although these records are not in sequence order in their table(s). My problem is that I must manually assign a sequence number to each stop and there may be a hundred or more stops on a route which changes as stops are added or deleted which would effect the sequencing. How can I automate assigning a sequence number for printing to each stop and have it automatically re-number the sequencing as stops are added or deleted? Will I need to write a query sort? Any suggestions will be appreciated. Thank you! |
Thread Tools | |
Display Modes | |
|
|