表格进行计算 [英] Form to perform calculation

问题描述

你好，


我正在为我的部门设计一个项目来设计一个计算预算的表格。我一般都不太了解访问或编程。


此时，我正在尝试设计一个表格，我可以在表格中添加字段。 （至少我认为这是我想要做的）。表单当前为每个类别的员工都有一个文本框，该文本框绑定到表。每个员工类别都有不同的规则来确定最终预算。我需要的是在一个类别中添加额外员工的方法：例如，一个预算可能有三个第一类员工，两个五类员工和十个第八类员工。这些员工中的每一个都将拥有与之相关的附带信息，例如姓名，工资，工作百分比等......


我的表格目前有每个员工类别的列表。我想要设计的是一个表单或子表单，我可以在其中输入每个cateogry中的员工数量，并自动创建一个新字段或新文本框。


感谢您的帮助。


James

Hello,

I am working on a project for my department to design a form to calculate budgets. I really don''t know much about access or programming in general.

At this point, I am trying to design a form where I can add fields to a table. (At least I think this is what I want to do). The form currently has a text box for each category of employee, which is bound to a table. Every employee category will have different rules that determine the final budget. What I need is a way to add in additional employees within a category: for example one budget might have three category one employees, two category five employees, and ten category eight employees. Each of these employees will have will then have attendant information associated with it such as the name, salary, percent of effort etc...

My form currently has a listing for each employee category. What I would like to design is either a form or subform where I can input the number of employees within each cateogry, and a new field or new text box will automatically be created.

Thanks for your help.

James

推荐答案

我有一个一切都麻烦了。


你能否给我一些关于桌子的更多信息？

你能否列出表格中的字段和信息类型它存储。


请提供一个示例，说明当您创建新字段时情况会如何变化。

I have a bit of trouble following everything.

Could you give me some more information about the tables?
Can you list the fields in the table and the type of information it stores.

And please provide an example of how things would change when you "create a new field".

Hello Rabbit，


感谢您的快速回复。


我不知道这是否是我希望完成的最佳表设置，但是现在我为每个类别的员工都有一个表TblEmployeeCategory。这有一个自动生成的密钥号。它是一个最多50个字符的文本表。我还有一个TblEntry，它是FrmEntry所基于的形式。这有一个项目开始日期字段（短日期），多年字段，工资字段（货币），夏天，冬天的努力百分比，以及员工类别的列表框。似乎我所拥有的东西会起作用，因为每条记录代表一个人，但是为了计算，我需要能够区分一个预算的开始和另一个预算的结束。例如，一个预算可能有十个人，而另一个预算可能有二十个或更多。此外，任何一个人的项目开始日期，结束日期和年数都不会改变。所以我想要设置的是一个表单，一旦我输入第一个人的数据，第二个人的字段就会自动在该表单上创建。我想我希望每个表单代表一个预算，如果这是有道理的。


再次感谢您的帮助

Hello Rabbit,

Thank you for your quick response.

I don''t know if this is the optimal table setup for what I hope to accomplish, but right now I have a table TblEmployeeCategory for each category of employee. This has a key number which is auto-generated. It is a text table with 50 character max. I also have an TblEntry, which the form FrmEntry is based on. This has a Project Start date field (Short Date), a number of years field, a salary field (currency), a percent of effort for summer, winter, and a list box for Employee Category. It might seem that what I have would work since each record represents one person, but for the calculation, I need to be able to distinguish where one budget begins and another ends. For example one budget might have ten people, where another would have twenty or more. Also, the project start date, end date, and # of years won''t change for any one person. So what I would like to have set up is a form where once I enter the data for the first person, the fields for the second are automatically created on that form. I guess that I want each form to represent a budget, if that makes sense.

Thanks again for your help

另一件事：


如果选择某些员工类别，年度年份的衡量方式不同。

One other thing:

If Certain employee categories are selected, the annual year is measured differently.

这篇关于表格进行计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！