Calculating Sums in Form

[aml5171]

http: //i53.tinypic.com/5b8x9u.jpg (remove the space between the http: //...)

Hi everyone,

I have built a database with 5 tables to track and record oil rig vessels, their policies, owners, and type of products.

What I am trying to calculate is the total "exposure" that an owner has. A single owner can own several vessels, each with several products with their own exposure.

What I would like to do is have a query or function to sum all the exposures for each particular owner.

When I try to use the Totals, then Sum in the query I am just getting the exposure from each individual vessel's product and not totaling all the exposures for that owner.

I am not sure if this is a function I should be creating in my form design view or before that in my query, but I would like to sum each exposure (all the rows from the exposure column) for a single owner, as I set up the query by owner.

Any suggestions are greatly appreciated.

 

[John Big Booty]

You will not be able to do this in a single query but will need to use a series of cascading queries.

Can you post a copy of your DB? ('03 version for preference)

You will be able to do this if you zip your DB and then upload it with your post by using the Paper-clip icon at the top of the posting window

 

[aml5171]

Attached below is my database so far. There is very limited data in it as I plan on only using 2011 data which we have not fully finalized. The data in there currently is arbitrary and just space fillers to test out my database as i built it.