有没有办法在访问2000上的查询中运行循环？ [英] Is there any way to run a loop within a query on access 2000?
问题描述
需要根据
年期间的多个因素计算总和。我可以使用公式^ x作为其中的一部分，但需要总数来支付
总和而且到目前为止只能通过一个循环
in一个表格。
基本上，我有钥匙金额
目前储蓄
当前工资
当前存款金额
当前利息
我必须每年增加生活费用
新工资意味着不同的美元金额用于储蓄
每年不同的存款意味着不同的利息
所有这一切，加到起始余额，而不是从全部开始
再次为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
< a rel =nofollowhref =http://www.pcdatasheet.comtarget =_ blank> 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 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?
Jeff
You need to use a totals query grouped on Year and Individual. You will
probably need some calculated fields in the query as well. Click on the
Sigma (looks like E) button on the toolbar at the top of the screen. You can
then change Group By under any field in the query to an expression. Explore
and see what is available here.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Crimsonwingz" <je**@goldwingz.com> wrote in message
news: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?
Jeff
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
Now that you have defined the problem more specifically, a totals query is
not the solution. This is a finance problem; look at financial functions in
the Help file. You will need to use more than one to get your answer.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Crimsonwingz" <je**@goldwingz.com> wrote in message
news: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上的查询中运行循环？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
