How to get a total of a particular product

A

AccessDB

I have a textbox called Engine Manufacturer on a Report footer. This
texbox gives me the type of engine that is on the product. I also have
a textbox called Annual Qty Est (also on a report footer). This
textbox give the number of engines that is on that particular product.
I have 2 questions.

1. I want to know the code to put in my textbox control source to see
only the Annual Qty Est for a particular Engine Manufacturer. Example:
In the Engine Manufacturer column in the report I have an engine
called "BS". I want to know only the Annual Qty Est for "BS" engines.

2. To further go on this, I also want to the the percentage for only
"BS" engines. Example: Lets say that on the report the sum of all
Annual Qty Est is 100,000. Out of that, "BS" engines is 10,000 out of
that 100,000. I know this is 10%, but I don't know the code to put
into my control source for that textbox.



Can I please get some help on this matter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a total in on a report in a textbox 0
Count the number of times something shows up 8
How to bulk add section breaks after a particular combination of letters/numbers 0
DLookup in Continuous form 0
help w indirect and index,match 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Please help me choose a product for the task 2
Total or pre calculated column 5

Top