仅显示最高/最高版本 [英] Display only Top / Max Revision
问题描述
亲爱的朋友们,
我正在建立一个关于图纸传入/传出历史的数据库。
我有一张桌子的字段
DWG#
Rev
日期
传送
充电
我有一个DWG#,其中有以下Rev
0A
0B
0C
2A
2B
2C
3A
现在3A是最新的。我想创建一个基于查询的报告,该报告仅显示绘图的Top / Max Rev的DWG状态。
当我创建&运行这种查询,它显示所有记录。但是我只希望获得最高版本/最高版本的一个记录。
请有人帮助我...附表是附表。谢谢...
Irshad Ahmed
Hi dear friends,
I am making a database regarding Drawings Incoming / Outgoing history.
I have a table''s fields
DWG#
Rev
Date
Transmit
Incharge
I have a DWG# which has following Rev
0A
0B
0C
2A
2B
2C
3A
Now 3A is the latest. I want to make a query based report which shows the DWG status of only Top / Max Rev of the Drawing.
When I create & run such kind of query, it shows all the records. But I want only One Record of the Top Rev / Max Rev.
Please some one help me... Access Table is attached. Thanks...
Irshad Ahmed
推荐答案
嗨
我认为问题在于表结构。
你有 Text 字段对于 REV 等..
Access无法理解或计算文本字段中的最大值或最小值(这是我所理解的)
Hi
I think the problem is with Table structure.
You have all Text fields for REV etc..
Access is unable to understand or compute maximum or minimum values in a Text Field (This is what I understand)
那你建议什么应该是字段格式?
我们如何定义AlfaNumaric。 Plz guide。
So what you suggest what should be the field format ?
How can we define AlfaNumaric. Plz guide.
在给出任何建议之前,我想知道你在REV领域背后的逻辑。我的意思是,为什么你只想要字母数字字段,对于REV。
如果真的需要在那里有字母数字字符,那么你可以创建一个单独的表,你可以在其中维护一个数字字段和字母数字字段(文本字段)。然后你可以在原始表格中引用这个表格。
Before giving any suggestion, I would like to know your logic behind REV field. I mean, why do you want to have alphanumeric field only, for REV.
If it is really required to have alphanumeric character there, then you can make a separate table where you can maintain a numeric field and a alphanumeric field (Text field). Then you can give reference of this table in your original table.
这篇关于仅显示最高/最高版本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!