L
Lin
I have a query which has parameters from the
Form.(Forms!Products!Poduct_Name) with the number of Products. The numbers of
Products are count of number of IDs.
That is
Product Name, Count(Name).
AB 35
BC 82 etc..
My issue is to I would like to calculate the percentage of this Counts like
Product Name, Count(Name). Percentage
AB 35 (Count/Total(Count))
BC 82 etc..
Is there any way I can do this in a query. (Total(Count) is always varying
according to the selection of the Form)
Any help. Really Appreciated
Thank you
Form.(Forms!Products!Poduct_Name) with the number of Products. The numbers of
Products are count of number of IDs.
That is
Product Name, Count(Name).
AB 35
BC 82 etc..
My issue is to I would like to calculate the percentage of this Counts like
Product Name, Count(Name). Percentage
AB 35 (Count/Total(Count))
BC 82 etc..
Is there any way I can do this in a query. (Total(Count) is always varying
according to the selection of the Form)
Any help. Really Appreciated
Thank you