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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access