如何对地址数据集进行排序？ [英] How to sort a data set of addresses?

问题描述

我试着制作一个显示地址的数据表。我有田地：房子没有，街道，城镇，城市。


当我尝试排序时，房屋号码不合适？我如何对它们进行排序？

I am tryn to make a datasheet to show the address. I have the fields: house no, street, town, city.

When I try to sort, the house numbers are not in order? How can i sort them?

推荐答案

您的问题是由于您的门牌号显然是文本字段而没有实数而导致的。

作为门牌号码可以有后缀，你需要拆分。该字段分为两部分，一个数字定义为数字和（可选）后缀。要对这两个字段进行排序需要使用。


Nico

Your problem is caused by the fact that your house number is obviously a text field and no real number.
As a house number can have a suffix, you''ll need to "split" the field in two part, a number defined as number and the (optional) suffix. To sort both fields need to be used.

Nico

感谢您的回复。但是我如何分裂这个领域呢？我是新来的。提前谢谢。

Thank you for the response. But how do i split the field? im new to access. thanks in advance.

布林，你的问题很缺乏信息。


得到那个固定然后我们不会猜到这么多你在说什么。

Brin, your question is very short of information.

Get that fixed then we won''t be guessing so much what you''re talking about.

这篇关于如何对地址数据集进行排序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！