请大侠帮忙，成功了我有谢谢

sjds333

select 乡镇,村,'地类' as 分类,地类 as 明细分类,面积 from [咸安$] union all
select 乡镇,村,'权属' as 分类,权属 as 明细分类,面积 from [咸安$] union all
select 乡镇,村,'土层厚度' as 分类,土层厚度 as 明细分类,面积 from [咸安$] union all
select 乡镇,村,'坡度' as 分类,坡度 as 明细分类,面积 from [咸安$] "
这样也提示不对，版主看看。

bolliy

原帖由 sjds333 于 2009-5-25 13:25 发表
试了一下用Sql：
select 乡镇,村,面积,地类,"地类" as 分类 from [咸安$] union all
select 乡镇,村,面积,坡度,"坡度" as 分类 from [咸安$] union all
select 乡镇,村,面积,土层厚度,"土层厚度" as 分类 from  ...

select 乡镇,村,面积,地类,0 as 坡度,0 as 土层厚度, "地类" as 分类 from [咸安$] union all
select 乡镇,村,面积,0 as地类, 坡度,0 as 土层厚度,"坡度" as 分类 from [咸安$] union all
select 乡镇,村,面积,0 as地类, 0 as 坡度,土层厚度,"土层厚度" as 分类 from  ...

老墨

谢谢朋友们，按地类、权属的我已解决，就是按坡度和土层厚度的有一个关于分段设置还不知道怎么设置，还请朋友们指教！

abcjian

给你回了短信没有看到吗？
“把坡度放在第一列，选中全部小于15的，然后分组，再选中15-20的在分组！均为手动分组！”

sjds333

select 乡镇,村,面积,地类, 0 as 权属, 0 as 坡度, 0 as 土层厚度, "地类" as 分类 from [咸安$] union all
select 乡镇,村,面积, 0 as 地类, 权属, 0 as 坡度, 0 as 土层厚度,"权属" as 分类 from [咸安$] union all
select 乡镇,村,面积, 0 as 地类, 0 as 权属,坡度, 0 as 土层厚度,"坡度" as 分类 from [咸安$] union all
select 乡镇,村,面积, 0 as 地类, 0 as 权属, 0 as 坡度,土层厚度,"土层厚度" as 分类 from [咸安$]
也不行，提示：参数不足，期待是7

sjds333

认真检查还是面积(M)中的(M)漏的缘故,呵呵,真粗心!

[ 本帖最后由 sjds333 于 2009-5-26 18:56 编辑 ]

penghaifeng

在版面上似乎做不到楼主要求的格式,下面是图示

[ 本帖最后由 penghaifeng 于 2009-5-26 20:16 编辑 ]