Expressions based on several columns

[jduran2]

I have a query that was created with data from several tables in my database (seen below). I'm currently interested in creating a new field in my query that performs some expression or calculation based on several of the fields in the current query.



For example, in the AnalyteName field we see values for W,W2,W3,W4,W5, and W6 with an associated response and RSD value. In this example, W6 is the total or the sum of W through W5. I would like to find the percent of each value from the total for the whole query. My ideal output would show W/W6, W2/W6,W3/W6, etc.... in new field next to the respective analyte. Note that each W-W6 is unique based on the SampleIndex field. I've worked with basic expressions, but nothing like this.

Thank you

[aytee111]

Make a separate query that does the totaling and then link to it by key (SampleIndex?). That query will contain just the key field and the calculated values.