Calculation in a query

[aattas]

Hello.
I have a case of calculation of addition and division, I need to show the result in a report as follows:
Cat1=3
Cat2=4
Cat3=5
Total of Insp: 20

The calculation should do the following:

Cat1 +Cat2 +Cat3 / Total of Insp.

Should I do this in a query or VBA?

Thanks

 

[arnelgp]

you do it in query.

 

[theDBguy]

Hi. Are Cat1, Cat2, and Cat3 names of your fields?

 

[aattas]

Wow. Thanks for the reply. But can u show me how it is done?. Please

 

[aattas]

Yes. There are fields.

Thanks

 

[arnelgp]

select (cat1 + cat2 + cat3)/[total of insp] as ColumnName;

 

[theDBguy]

Yes. There are fields.

Thanks

Okay. Ignoring the apparent issue with normalization, give Arnel's suggestion a try and let us know if it works for you.