Custom Sort on a report

[npa3000]

So I have, a report that shows all the customers and their total orders.

I want to custom-sort this report ( alphabetically, ascending order, descending order based on the total number of orders) without creating multiple queries and reports.

Is there any solution with VBA code?

Thanks

 

[theDBguy]

Can you show us some sample data to show the sorting order you want? Normally, you don't need to use VBA for that.

 

[CJ_London]

reports have their own sorting functionality, any sorting done in the recordsource will be ignored. Go to report design and click on the grouping and sorting option in the design ribbon to display the appropriate window.

Not sure what you are asking but implies if you have

customer..OrderTotal
A......................5
B.......................6
C......................4
D......................5

you want the order

B...6
A...5
D...5
C...4

in which case sort first by order total and then by customer name

 

[npa3000]

I have a query that returns the clients and there total orders. That query is used by a report. And I want to create a custom "sorting filter" that sorts my data based on the client's name and the increasing order of orders.

It is possible with some trick or i have to create another report that sorts the data differently?

 

[CJ_London]

still doesn't make sense - I provided an example of what I think you mean - suggest you do the same