I am using an Access database to manage some inspection information. I have a scenario where I have to dynamically number points associated with a location. The point numbers will be sequential starting a 1 for each location. The PrcReq drives the order based on a percentage (calculated elsewhere). One gotcha, whenever PrcReq = -100% it indicates an error and these should be at the bottom of the sort order.
Thank you for the support!