Query Challenges
Nothing unleashes the power of a database better than a query. Queries are even used behind the scenes in Access to perform many tasks without the user even being aware that they are going on. However, there are situations that can confront the developer that can prove to be challenging, to say the least. The query often is the first place the developer turns to for help. Yet, the best way to apply this powerful tool is not always apparent.
Let’s say you are working for an insurance company and your boss approaches you with what they call a “stratification report” in the insurance business. He wants the dollar amounts to be grouped in levels, or “strata,” sorted with the smallest levels first. To determine the frequency of the ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
