Prev: access 2007 use the old query builder format
Next: Dynamic query -How?
From: mh_amri on 26 Dec 2009 09:35
hi guyz,we have little office and want to make some regular thing machinary
here it is:
we sell stuffs(for example think us as a newspaper company) , we give
newspaper to our seller and then they return the amount of newspaper that
remains at the end of the week , and because every day have a special rate
for income its important to calculate the sell amount from beginning
for example i give 150,100,250,400 newspaper to the seller and at the end of
the week he claim 300 of them has been sold, it means he sold out(*) 150 in
first day , and 100 in 2nd day and 50 in 3rd day9(**), and must return 200
for 3rd day and 400 for the 4th day
for this purpos i made a query that collect data about the day and the
amount that we gave the seller, and designed a form that take the amount of
that the seller sold out(this amount is a number for a whole week, for
example 300 ) , the problem is calculating the sold amount for each day(see
from * to **) , because each day have a rate value that it has read from
another table and multiply by the amount that sold on that day
i mean i want to do generate a table like this:
[seller] [day] [give amount] [sold amount] [retun amount]
1 1 150 150 0
1 2 100 100 0
1 3 250 50 200
1 4 400 0
400

my problem is calculating the the [sold amount] , the weekly returned amount
has entered in a form (here is 300) i have to give 300 to access and generate
the [sold amount]
i used many ways, but because the calculation of each row need to access the
last row data all of that way failed
anyway , any comment will appreciate

 | 
Pages: 1
Prev: access 2007 use the old query builder format
Next: Dynamic query -How?