How to return mutliple calculations to a single column

[Hex92]

I am working with environmental data and I am trying to calculate corrected recovery data for PCBs.

Its difficult to describe so I have attached an screenshot of an excel file with data from a query that I built that I thought would get me going in the right direction.

I want to divide the values in column D (UNCDry) by the appropriate number in columns E-M based on the value in column C.

So all the UNCDry values with 'tri' (NumChlor- Col C) would be divided by the value in column F.

Then all the UNCdry values with 'tetra' would be divided by column G...and so on across through deca.

In the end I need to have a single column with the corrected values just like I do for the UNC data.

I tried building a different query for each set (tri, tetra, penta, etc), but I couldn't figure out how to then combine all those in a single column of corrected data.


Thanks

[June7]

Construct a field in query with an expression. Something like:

[UncDry] / Switch([NumChlor]="tri",[triPCB], [NumChlor]="tetra",[tetraPCB], ...repeat for remaining columns)

[Hex92]

THANK YOU!

I knew there had to be an easy way to do this and that worked perfectly. I spent more time than I care to admit trying to figure out how to do that.