Running total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is linked to a table for sales.
I have a querie that calculates the total number of a product that sold
How do I insert a textbox that shows me the total avalable for selling.
 
Esrei

Based on your description so far, it doesn't seem like you have all the
factors you need for a calculation. If you know how many of a product have
been sold, wouldn't you also need to know how many of that product were
originally available before calculating the "remainder"?

You might want to take a look at the DCount() function -- it might help you
fill an unbound textbox on your form.

Good luck

Jeff Boyce
<Access MVP>
 
Sorry I know do know the original available.
I did a querie with the wizzard Total stems and sum of stems sold. If I
insert another field Total stems-sum of stems sold the querie keeps asking
for a parameter value for sum of stems sold.
 
Have you tried "chaining" two queries togther? Use the one you already have
as the source for a second, in which you do the calculation using the
results from the first.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top