Calculations

[Slicemahn]

Hi,
I am new to Access and need some help in building a calculation. I have performed a simple query that involves three fields: Name, ID and Activity. A fourth field has been added to obtain a count of each Activity. How do I write a formula that would calculate the percentage of one particular activity against all activities?

Thanks

 

[HomerJ]

I would think that adding a field that would divide your Activity Count field by a DCount of all activities formatted as a percentage would give you the result you seek.

 

[Slicemahn]

Thanks for the reply..

However, what I am looking for is individual totals. For example if Bob sells 5 oranges, 2 apples and 1 mango. What is the percentage of apples to total fruit sold for Bob?

Thanks,
Colin

 

[Andrew Fergus]

Hi Colin
I'm not sure if this is what you want, but for what it's worth I always find it much easier to do the % calculations on a report instead of a query. Will you be looking at the sales results and %'s in your query or on a report?
Andrew

 

[Slicemahn]

Hi Andrew

Andrew,

I was hoping that the calculation could be made on my query and then populate a report with use of that same query. Which method is easier?

Colin

 

[Andrew Fergus]

I would recommend extracting all of the necessary data in the query and then doing the % and total calculations on the report. As I said, these sorts of things are much easier on the report (versus the query) plus I believe they are less resource intense (although I could be wrong).
Andrew