在Access中组合日期和自动编号字段 [英] Combine date and autonumber field in Access

问题描述

我想结合日期字段和自动编号字段在访问表和访问表单上创建一个事件编号字段

I want to combine date field and autonumber field to make a Incident number field in access table and on an Access form

推荐答案

请查看此主题并考虑添加必要的项目以给出答案。

（发布指南：请阅读在发布到论坛前仔细评论）


版主。

Please look in this thread and consider adding those items necessary to give an answer.
(POSTING GUIDELINES: Please read carefully before posting to a forum)

MODERATOR.

将两个基本字段合并为一个被认为是糟糕的设计。

标准化方法是使用从两个字段构造的复合键。这可以通过选择两个字段并按下表格设计模式中的按键来实现。


最后在表格上只读字段可以与以下算法一起使用：

= [AutoID]& " " &安培; [SequenceNo]

甚至可以使用格式化来显示像001那样的1。


得到这个想法？


Nic; o）

Combining two basic fields into one is considered bad design.
The "normalized" way is to use a composite key, being constructed from both fields. This is achieved by selecting both fields and pressing the Key button in the table design mode.

Finally on a form a "read only" field can be used with an algoritm like:
=[AutoID] & " " & [SequenceNo]
Even formatting could be used to get a 1 displayed like 001.

Getting the idea ?

Nic;o)

请帮助我们确定日期并在日期结束时添加自动编号。

Please help need to have date and add autonumber to end of the date.

这篇关于在Access中组合日期和自动编号字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！