访问2003中的重复数据问题 [英] duplicate data issue in access 2003

问题描述

大家好！



美好的一天...



我的访问权限有问题2003.我的表中有重复的数据。当第一列在第一列中有重复时，第二列需要为零。我有这个..

Hi guys!

Good Day...

I have a problem in my access 2003. I have a duplicate data in my table. The 2nd column needs to be zero out when it has duplicate in 1st column. Tody i have this..

TicketNumber ShippingContainer  Weight
   SRN1         2-0002-01        56
   SRN2         2-0002-01        56

                         TOTAL WT:  112

但它应该是这样的...

But it should be like this...

TicketNumber ShippingContainer  Weight
   SRN1         2-0002-01        56
   SRN2         2-0002-01             

                         TOTAL WT:  56

票号是唯一的，shipping_container_number是相同的。我需要标准或其他东西，所以wieght将不会重复，如上图所示。集装箱的运输将被运送到不同的地方，这就是为什么它有不同的ticket_number但我仍然需要它们显示所有类似的东西。



这是否可以访问。请帮忙。我真的需要这个来为我的报告工作。在此先感谢...更多Powe和上帝保佑...



：）

The ticket number is unique and the shipping_container_number is the same. I need criteria or something so the wieght will not be repeatative as you can see in the illustration above. The shipment of a container will be shipped to different places thats why it has different ticket_number but still i need them to display all like that.

Is this possible in access. please help. I really need this to work for my report. Thanks in advance... More Powe and God Bless...

:)

推荐答案

I我不确定这是多么可能，这是你要求的格式。您可以通过从装运箱中选择不同的值来获得总计。这是你担心的总重量，所以我怀疑你想要单独计算它，做一个不包括票号的明显选择。我可以告诉你如何编写SQL来做到这一点，但我不知道如何通过不在Access中编程来实现它。

I am not sure how possible this is, in the format you''re asking for. You can get totals by selecting distinct values from shipping container. It''s the total weight you''re worried about, so I suspect you want to just calculate it separately, doing a distinct select that does not include the ticket number. I could tell you how to write SQL to do that but I have no clue how to do it by not programming in Access.

这篇关于访问2003中的重复数据问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！