Insert serial number and sort by that in a query - HELP!!

[sonaljain123]

Hi,

So I have a query which selects 74 account numbers, balance numbers for a date that I select in a form. I have embedded this query in a VB Code of the form and have also created a button which selects the date and runs the query.

But because I want to view the result in a particular order, which is not sorted, what would be the best way to do the same?

I thought I could add another column in the query that would assign 1,2,3,...74 to each of the row and then sort the results according to this column. Any ideas on how to code it up in VBA?

Thanks!

 

[Taruz]

Hi..

If you want to sort it, if only the form, refer to the example.

If you want to see just a query, your query (SQL view) will be needed.

 

[sonaljain123]

I am not sure I follow Taruz..

I am attaching my tables in an excel sheet below for you to see...