Dynamically Number Records in by Grouping using Access 2007
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.