implement expressions

[quandore]

Hello everybody,

i'm a beginner i hope you'll have patience! i just made a form in access that allows me to filter some product group's of a query. this query contains:

product groups; material numbers (single products); type of vehicle; population (how many vehicles have been sold in a particular market).
with the form i just created i can filter for the product groups. a product group contains several material numbers. the vehicle types can have only 1 population.

Now i want to make access do simple math within the outcome of the filtered query.



a) to sum of the filtered population (i.e. the total of population within that particular product group)
b) calculate the ratio between the filtered population and the total of population.

i have no idea where to start!

sorry if it's confusing... i'll try to be more precise if you want to ask something.

and thanks!

[dblife]

You could use this query to make a form in continuours view and have boxes in the form footer to display what you want to calculate.
If the 'filtered population' figures are displayed in a control called 'txtFilteredPopulation', drag a new text box onto the footer and write inside it,
'=sum([txtFilteredPopulation])
That will show you the sum of what that column is.
You can do various arithmetic functions using this method.

[quandore]

You could use this query to make a form in continuours view and have boxes in the form footer to display what you want to calculate.
If the 'filtered population' figures are displayed in a control called 'txtFilteredPopulation', drag a new text box onto the footer and write inside it,
'=sum([txtFilteredPopulation])
That will show you the sum of what that column is.
You can do various arithmetic functions using this method.

Hi, and thank you for your answer.
could you please explain into more details the procedure i should follow?

sorry i'm a beginner with access...

[dblife]

consider the two images shown.
the table shows products cost and qty.
i have made a simple form in continuous view and in the footer of the form, pulled a text box onto the footer and written the code shown [image 1]
when i switch to normal view on the form, the calculation is shown [image 2]

[quandore]

ok, i managed to have the subtotals displayed in the form. i added a text box in the subform and put the formula =sum([fieldname]) and then i added another text box into the form, and made a ref to the control in the subform. so good so far.
now i need to have the SUPER-TOTAL, not just the "filtered total". so i actually need to display the sum of the entire population so that i can calculate the ratio between the filtered pop. and the total pop.
i need your help here, coz i've been struggling all day to manage this but i miserably fail.
the problem is, how can i obtain the total population in the form? this way i only obtain the total of the population filtered by product groups. i need the total of the population of all the discount groups combined.
any hint?

[quandore]

dblife thank you for your help. i just read your post. i had to manage that part myself coz i'm out of time. if you read my last post maybe you will find the time to help me with this second step?
thank you,
Francesco

[dblife]

for this, you might find the 'DSum()' function useful.
dsum refers to domain - a domain is a data source whether its a table or a query.
the syntax is
DSum("pCost", "tProducts")
or it could just as easily be applied to a query which calculates the total per item using cost and qty.

[quandore]

it worked quite smoothly. thank you!