446,163 Members | 944 Online
Need help? Post your question and get tips & solutions from a community of 446,163 IT Pros & Developers. It's quick & easy.

# calculation

 P: 92 Hi I have a problem in calculation. i have a access table that have entry for differnt dates. the data entry into this table is cumaltive and weekly and i hav eto get a daily report. i mean it shows todays sell 2500\$ tomorow the sell is 5600\$ but actually it is 3100\$ the day after 7600 but actually it is 1000\$ i dont know how can i say minus today from yesterday for each record? the sell is cumelative for each week . at the begining of the week it will start from 0 i would appreciate any help thanks Voroojak Dec 10 '07 #1
5 Replies

 100+ P: 167 Hi Voorojak! Do you keep the info about the sales for only one week long? That would be strange. You might need this information for monthly and yearly reports. Could you enter sales separately for only one day/date in your Sales table. Then you could make a query to select from Sales table only sales for the week (between Start date and End date) you choose. This way you could make monthly reports too (just enter: start date = 1st of January 2007, and End date = 31st of January 2007) Ofcourse you must have a Total on that report that shows total amount of sales for specified period. Other solution would be to have another cell containing cumulative value one day behind (total from yesterday). The difference between these two cells would be amount of sales for today. I'll be here if you have more questions on this. H. Dec 10 '07 #2

 P: 92 Hi thanks for your reply i do not just keep the sale report just for one week. i meant that the sale is cumaltive for each week. the table is some think loolk like this run_date week_ending Sup sale_ID Sale# 10/12/2007 15/12/2007 MNA BHJ 3 10/12/2007 15/12/2007 MNA KLP 5 10/12/2007 15/12/2007 GTF SUP 6 10/12/2007 15/12/2007 DFO SUP 5 11/12/2007 15/12/2007 MNA BHJ 7 11/12/2007 15/12/2007 MNA KLP 8 11/12/2007 15/12/2007 GTF SUP 7 11/12/2007 15/12/2007 DFO SUP 9 but actualluy tthe sale BHJ for 11/12/2007 is 4 not 7. because he made 3 sale on 10th. but the report is showing the cumaltive value each week is start from monday to sunday What i have to do is that i add another column or query or what wver that i can say that this person on this date that will end by this week and supervisor is this person made 4 sales on 11th thanks alot for ur help Dec 10 '07 #3

 100+ P: 167 Hi Voroojak! Is this problem occuring only with reports, and not with forms? Check the Sales# control on the report. The running sum property should be set to none. If the database is not too big you could attach it here so I can have a detailed look (or you can make a similar database just for that purpose). Please explain how exactly do you enter info into the Sales# control. If you use VBA code maybe Sales# variable is not empty before the next entry? h. p.s. To attach the database make a zip file and after replying to this thread hit the Edit/Delete button on your lower right. Then you will have an option to add attachments! Dec 11 '07 #4