The reason I need to generate SeqNo is that often times we need to export the rooming list to airlines, and it requires sequence number. The table structure is as below:
the query I need:
Please help. Thanks.
It's a rooming list. I will write to you tomorrow. Thanks.
Yes. Really simple in a report - create a text box with the Control Source set to =1 and Running Sum set to Yes. A bit more tricky in a query, but I would need to know the structure of your tables first.
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|