Search results

Is there a way to retrieve 80% of records by the value, instead of record count? For instance, given a list of late orders, I want to review the ones that cause 80% of the total value of late orders. In Excel, I'd sort descending, create a column with % of total value, then an additional...

Hi! I've inherited someone's big-a**ed query and am being asked to do make updates as the users figure out what they need. The query reads data from a linked file. That data comes from SAP and takes a couple of hours to download. The users would like to do small downloads and run the query...

Hi! I'm a pretty light Access user. I love it, it's fun, I just don't get a lot of excuses for it, so I end up learning from near scratch every time I do. :banghead: At work, I do process improvement stuff, project work and lots of analysis. I really need to figure out what I want to be...