How it set it in a Query.

[cap.zadi]

Hey there,



Any usual help will be highly appriciated.

i have one query with two fields. so now want to add one more field of % calculations?


Faults Qty

How to do that?

thanks

zee

[June7]

What is the formula - columnA / columnB ?

Do this by creating a field with an expression. In query design view enter expression in a cell of the Field row. Access will give it a name like Expr1, you can change that to whatever you want. Access Help has guidelines on building queries.

[cap.zadi]

Hey, thanks to be here. No man, its not like that.

I have a Query with fields

Fault Qty
xyz 000

now how i can add the 3rd field which help to calculate the % of each with formula = (Qty/Total) so from where and how to get the total?

thanks

zee

[alansidman]

Look at this video

http://www.datapigtechnologies.com/f...centtotal.html

Alan

[cap.zadi]

yes man, it is done. thanks for help.