Access与Excel中的查找和文本计算 [英] Lookup and Text calculation in Access vs Excel
问题描述
我确定这很简单...
我可以在Excel中使用它,但我需要帮助它在Access中工作:
我正在使用表单来填充表格。我有名字和姓氏的字段。我想计算我可以在Excel中完成的全名(last,first)。我可以让它在Access中的FORM上工作,但它不会把它放在桌子上。
另外,在另一个表格中我有一个部门编号和部门名称。当我将部门编号输入表格时,我想让部门名称进入表格。
希望这是有道理的。
感谢您的帮助!
I''m sure this is simple...
I can get this to work in Excel, but I need help getting it to work in Access:
I am using a form to populate a table. I have fields for first name and last name. I would like to calculate the full name (last, first) which I can do in Excel. I can get it to work on the FORM in Access, but it won''t put it in the table.
Also, in another table I have a department number and department name. I would like to have it enter the department name into the table when I enter the department number into the form.
Hope this makes sense.
Thanks for your help!
推荐答案
我很确定这很简单...
我可以在Excel中使用它,但我需要帮助它在Access中工作:
我使用表单来填充表格。我有名字和姓氏的字段。我想计算我可以在Excel中完成的全名(last,first)。我可以让它在Access中的FORM上工作,但它不会把它放在桌子上。
另外,在另一个表格中我有一个部门编号和部门名称。当我将部门编号输入表格时,我想让部门名称进入表格。
希望这是有道理的。
感谢您的帮助!
I''m sure this is simple...
I can get this to work in Excel, but I need help getting it to work in Access:
I am using a form to populate a table. I have fields for first name and last name. I would like to calculate the full name (last, first) which I can do in Excel. I can get it to work on the FORM in Access, but it won''t put it in the table.
Also, in another table I have a department number and department name. I would like to have it enter the department name into the table when I enter the department number into the form.
Hope this makes sense.
Thanks for your help!
我是一个规范化的数据库,我们将这些名称分开,只是在查询中(或在未绑定的cq新字段中的表单上)我们使用如下算法:
= [LastName]& , &安培; [FirstName]
或
选择[LastName]& , &安培; [FirstName]作为来自tblYours的FullName。
部门编号和部门名称通常存储在一个单独的tblDepartment中。
现在在另一个表中只存储部门编号并使表定义中的字段为查找字样。领域。 (查看Lookup选项卡)。
获得想法?
Nic; o)
I a normalized database we keep those names separate, just in a query (or on a form in an unbound c.q. new field) we use an algoritm like:
=[LastName] & ", " & [FirstName]
or
select [LastName] & ", " & [FirstName] as FullName from tblYours.
department number and department name are normally stored in a separate tblDepartment.
Now in the other table just store the department number and make the field in the tabledefinition a "Lookup" field. (Check the Lookup tab).
Getting the idea ?
Nic;o)
查看本教程(规范化和表格结构)以获得对原则的更全面解释。我会推荐给任何刚接触数据库的人。
Check out this tutorial (Normalisation and Table structures) for a fuller explanation of the principles. I would recommend it to anyone new to databases.
我是一个规范化的数据库,我们将这些名称分开,只是在一个查询中(或者在我们使用的算法如下:
= [LastName]& , &安培; [FirstName]
或
选择[LastName]& , &安培; [FirstName]作为来自tblYours的FullName。
部门编号和部门名称通常存储在一个单独的tblDepartment中。
现在在另一个表中只存储部门编号并使表定义中的字段为查找字样。领域。 (查看查找标签)。
获取主意?
Nic; o)
I a normalized database we keep those names separate, just in a query (or on a form in an unbound c.q. new field) we use an algoritm like:
=[LastName] & ", " & [FirstName]
or
select [LastName] & ", " & [FirstName] as FullName from tblYours.
department number and department name are normally stored in a separate tblDepartment.
Now in the other table just store the department number and make the field in the tabledefinition a "Lookup" field. (Check the Lookup tab).
Getting the idea ?
Nic;o)
>
我仍然无法获得FullName来计算。我不知道为什么。
关于部门编号和名称问题,现在我可以得到部门名称的下拉列表,但我仍然需要选择正确的部门名称从列表中。当我输入部门编号时,我真的希望在现场输入正确的部门名称。
I still can''t get the FullName to calculate. I''m not sure why.
On the department number and name issue, now I can get a drop down list of the department names, but I still have to select the correct one from the list. I would really like it to put the correct department name in the field when I enter the department number.
这篇关于Access与Excel中的查找和文本计算的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!