In my table I have one column that lists part usage (number) in descending order. I have a second column with an auto number for ranking. So my highest used part ranks as number one.
Is there any way to verify the sort order on my usage column is descending as my rank number increases? The table is used as a reference for other functions. I'm just trying to verify the table was created correctly. With 2000 technicians and 600,00 parts in it it's immpossible to verify manually.
Thanks
JB
Is there any way to verify the sort order on my usage column is descending as my rank number increases? The table is used as a reference for other functions. I'm just trying to verify the table was created correctly. With 2000 technicians and 600,00 parts in it it's immpossible to verify manually.
Thanks
JB