Custom sort????? (1 Viewer)

[Emmanuel]

Hello people,

I have a need for a custom sorting on a report. Example:

I have this brands:

TIC
MCH
ROC
RAF
DNL
TRO
TTM

tHE THING IS THAT i NEED THEM TO REMAIN IN THIS ORDER WITHOUT HAVING TO ADD NUMBERS IN THE BEGINING. dO YOU KNOW HOW?

BEST REGARDS,
EMMANUEL

 

[WayneRyan]

emmanuel,

You can create a new table:

Table: tblBrandSort
Brand
SortOrder

Then when you run a report join the new table with your current
one and sort by SortOrder.

Wayne

 

[Vassago]

Set an autonumber for that table, then on the report. Go to sorting and grouping and group first by the autonumber.

Vassago

 

[Emmanuel]

Thanks

Great idea thanks...