I was wondering if it is possible to do a sum query but show the parts of the sum.
For example, my database tracks insurance policies on oil rigs, and a single rig can have multiple policies on it. Currently I am summing all the open policies on a particular rig by typing in a rig name and then receive that total number. What I would like to appear is each policy on that rig, then the total.
Anybody know if or how that would be done? Thanks in advance for the help.
I can attach the database if necessary.
For example, my database tracks insurance policies on oil rigs, and a single rig can have multiple policies on it. Currently I am summing all the open policies on a particular rig by typing in a rig name and then receive that total number. What I would like to appear is each policy on that rig, then the total.
Anybody know if or how that would be done? Thanks in advance for the help.
I can attach the database if necessary.