再次为X年。 表格保留默认值(利息,多少年,生活费用 增加) 一个表格在一个接一个的基础上可以正常工作,但我必须完成这项工作 几百个条目,打印在报告中。 甚至可能吗?我在哪里可以寻求帮助? 杰夫 解决方案 你需要使用一个总计查询按年份和个人分组。您将会在查询中查询一些计算字段。 。点击屏幕顶部工具栏上的 Sigma(看起来像E)按钮。您可以 然后在查询中的任何字段下将Group By更改为表达式。探索 ,看看这里有什么。 - PC数据表 你的资源有关Access,Excel和Word应用程序的帮助 re******@pcdatasheet.com www.pcdatasheet.com " ; Crimsonwingz" < JE ** @ goldwingz.com>在消息中写道 news:11 ********************** @ l41g2000cwc.googlegr oups.com ... 需要根据一段时间内的多个因素来计算总和。我可以使用公式^ x作为其中的一部分,但需要总数才能在总和中携带并且到目前为止只能在表单中使用循环 基本上,我有关键款 当前储蓄目前的工资当前存款金额目前的利息 我必须得到生活费用每年增加工资新工资意味着不同的美元金额用于储蓄每年不同的存款意味着不同的利益所有这一切,增加到起始余额,而不是在X年里再次开始了 一张桌子保留了默认值(兴趣,多少年,生活费用增加) >一张表格在一个接一个的基础上可以正常工作,但我必须完成这项工作,才能在一份报告中打印几百个条目。 它甚至可能吗?我在哪里可以寻求帮助? 杰夫 以前从未使用过sigma,并且帮助没有显示出太多关于它的信息。什么 这样做? 想在这里想一个更好的例子...... 员工是35.节省了1000美元。每年25000。存入10% 的工资。获得5%的储蓄回报。每 年涨5%。 50岁(15岁)时需要查看他的位置 明年,储蓄是1000+ 2500(存款)+ 175利息。支付 增加到26250.基本上重复14次。 如何使用Sigma完成?问题太多了吧?每次 我觉得我在这个有趣的东西越来越好,我被抛出一个循环。 感谢您的回复!! Jeff 现在您已经更具体地定义了问题,总计查询是 而不是解决方案。这是一个金融问题;查看帮助文件中的财务功能。您将需要使用多个来获得答案。 - PC数据表 您的资源获取帮助访问,Excel和Word应用程序 re******@pcdatasheet.com www.pcdatasheet.com " Crimsonwingz" < JE ** @ goldwingz.com>在消息中写道 news:11 ********************** @ z14g2000cwz.googlegr oups.com ... 之前从未使用过sigma,并且帮助并没有显示出太多关于它的信息。这有什么作用呢? 试着在这里想一个更好的例子...... 员工是35.节省了1000美元。每年25000。存入她工资的10%。获得5%的储蓄回报。每年获得5%的加薪。需要查看他年满50岁(15岁)的情况 明年,节省1000+ 2500(存款)+ 175兴趣。支付增加到26250.基本上重复14次。 如何用Sigma做到这一点?问题太多了吧?每次我觉得我在这个有趣的东西变得体面,我被抛出一个循环。 感谢您的回复!! 杰夫 Need to calculate a sum based on a number of factors over a period ofyears. I can use formula ^x for some of it, but need totals to carryover in the sum and have only been able to do this thus far with a loopin a form.Basically, I have key sumsCurrent savingsCurrent SalaryCurrent deposit amountCurrent InterestI have to get cost of living added to salary each yearNew Salary means different dollar amount going into savingsDiffering deposits from year to year means differing interestAll of this, added to the starting balance, and than started all overagain for X number of years.A table holds the defaults (interest, how many years, cost of livingincrease)A form works fine on a one by one basis, but I have to make this workfor a couple hundred entries, to be printed in a report.is it even possible? Where can I look for help?Jeff 解决方案 You need to use a totals query grouped on Year and Individual. You willprobably need some calculated fields in the query as well. Click on theSigma (looks like E) button on the toolbar at the top of the screen. You canthen change Group By under any field in the query to an expression. Exploreand see what is available here.--PC DatasheetYour Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com"Crimsonwingz" <je**@goldwingz.com> wrote in messagenews:11**********************@l41g2000cwc.googlegr oups.com... Need to calculate a sum based on a number of factors over a period of years. I can use formula ^x for some of it, but need totals to carry over in the sum and have only been able to do this thus far with a loop in a form. Basically, I have key sums Current savings Current Salary Current deposit amount Current Interest I have to get cost of living added to salary each year New Salary means different dollar amount going into savings Differing deposits from year to year means differing interest All of this, added to the starting balance, and than started all over again for X number of years. A table holds the defaults (interest, how many years, cost of living increase) A form works fine on a one by one basis, but I have to make this work for a couple hundred entries, to be printed in a report. is it even possible? Where can I look for help? JeffNever used sigma before, and help doesnt show much about it. What doesthis do?Trying to think of a better example here...Employee is 35. Has 1000 in savings. Makes 25000/year. Deposits 10%of her salary. Getting 5% return on her savings. Gets a 5% raise peryear.Need to see where he is at when age 50 (15 years)next year, savings is 1000+ 2500 (deposit) + 175 interest. Payincreases to 26250. Repeat 14 more times, basically.How can this be done with Sigma? Too many questions, right? EverytimeI think I am getting decent at this fun stuff, I get thrown for a loop.Thanks for the response!!Jeff Now that you have defined the problem more specifically, a totals query isnot the solution. This is a finance problem; look at financial functions inthe Help file. You will need to use more than one to get your answer.--PC DatasheetYour Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com"Crimsonwingz" <je**@goldwingz.com> wrote in messagenews:11**********************@z14g2000cwz.googlegr oups.com... Never used sigma before, and help doesnt show much about it. What does this do? Trying to think of a better example here... Employee is 35. Has 1000 in savings. Makes 25000/year. Deposits 10% of her salary. Getting 5% return on her savings. Gets a 5% raise per year. Need to see where he is at when age 50 (15 years) next year, savings is 1000+ 2500 (deposit) + 175 interest. Pay increases to 26250. Repeat 14 more times, basically. How can this be done with Sigma? Too many questions, right? Everytime I think I am getting decent at this fun stuff, I get thrown for a loop. Thanks for the response!! Jeff 这篇关于有没有办法在访问2000上的查询中运行循环?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-07 06:39