Query products

[Steven.Foy]

Wonder if anyone can help?

Am trying to utilize a product within a query. I have 4 columns, the first contains a set of systems. the next 3 columns contain percentage availabilities of these systems. My query will group the systems together(i.e all sub-systems of system A will group together, similiarly all sub systems of system B would group together and so on).

The percentage availability of System A needs to be the product of the percentage of all its sub systems(confused yet????)

is it possible for me to do this?

I thought about maybe writing some vb code....but am not sure how to apporach it!

does anyone know an easy way?

I look forward to your replies!

 

[Steven.Foy]

total row

It would be ideal if i could select (product) in the totals row. But access seems to only allow sum, count, max etc

 

[Pat Hartman]

Do this in a report.

 

[Steven.Foy]

i can;t run this query in a report

have included the sql below.

What i need is to group by [equip desc] and then take a product of those [critav] and [feedback av] which are in each group

(see the attachment

SELECT [qry Sub-System availability].[Equip Desc], [CRITAV]*100 AS CRITAVP, [Feedback AV]*100 AS [Feedback AVP], [qry Sub-System availability].Compliance
FROM [qry Sub-System availability]
GROUP BY [qry Sub-System availability].[Equip Desc], [CRITAV]*100, [Feedback AV]*100, [qry Sub-System availability].Compliance;

If anyone has any ideas?

It doesn't seem to be too complicated.....but its got me beat!