Develop query to multiply two fields from different table/query based on criteria

[blackseabrew]

Goal: calculate volume of concrete displaced by various lengths and diameters of conduit in what's known as a ductbank.

1. volume per diameter conduit per foot of conduit is already calculated in a query
2. Each conduit is listed individually by conduit tag with length.
3. I have entered a criteria where the conduit size of the table and query are to be equal.

Not having any luck after that point. I am emailing from the computer without the db on it or I would include the tables and queries. Will send those when I get back from lunch.

This should be simple but it's blowing me away.

Thanks for your help.

[orange]

Your diagram and post leave a lot to imagination.

If you have conduit/cables etc running within a concrete structure, do you have such conduit in direct contact with the concrete? I have seen structures where there is some sort of rectangular space in which pipes/conduit or cables are placed. In such a case the amount of concrete displaced from that structure is related to the size of the rectangular space and the length of the space within the concrete structure.
Rectangular space say 6" x 3" and 20 feet long would have a volume (lxwxh) or (.5 x .25 x 20) = 2.5 cu ft.

If you are putting conduit directly into concrete, and have circular conduit

Space occupied by circular conduit is pi x Radius x Radius x Length or (3.1415 *R*R*L) where R and L are in the same unit (in, ft, cm...) and result will be cubic units.

Not sure if that is what you are asking.
Good luck.

[blackseabrew]

Your diagram and post leave a lot to imagination.

If you have conduit/cables etc running within a concrete structure, do you have such conduit in direct contact with the concrete? I have seen structures where there is some sort of rectangular space in which pipes/conduit or cables are placed. In such a case the amount of concrete displaced from that structure is related to the size of the rectangular space and the length of the space within the concrete structure.
Rectangular space say 6" x 3" and 20 feet long would have a volume (lxwxh) or (.5 x .25 x 20) = 2.5 cu ft.

If you are putting conduit directly into concrete, and have circular conduit

Space occupied by circular conduit is pi x Radius x Radius x Length or (3.1415 *R*R*L) where R and L are in the same unit (in, ft, cm...) and result will be cubic units.

Not sure if that is what you are asking.
Good luck.

Sorry about the sloppy post kudos to you to understanding it. I guess Access 2007 doesn't have PI function. I haven't used it for a decade. And not I'm expected to know everything at once.

[orange]

Glad my guesses helped.
You can set a variable to be "pi"

Dim myPI as single
myPI = 3.14159 'you can find more decimals, but i think that'll be sufficient.

Good luck with your project.