A
AccessDB
I have a textbox called Engines Manufacturer. This texbox gives me the
type of engine that is on the product. I also have a textbox called
Annual Qty Est. 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 Engines Manufacturer.
Example: In the Engines 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.
type of engine that is on the product. I also have a textbox called
Annual Qty Est. 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 Engines Manufacturer.
Example: In the Engines 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.