主题：输入问题

请问我的表有一列设置为数值型，我想输入0416，可显示为416，该怎么设置

[这个贴子最后由Czy在 2007/10/08 04:29pm 第 1 次编辑]

其它软件也一楼，数值型前面整数是不可以有0的。
你这种要求只能将列类型改成字符型。

egd文件下载

各位,上表的帐务清单 如何按帐号提取前三个表的数具,填充相关币种金额中.

-=-=-=- 以下内容由 barryliu 在 2008年03月14日 10:13pm 时添加 -=-=-=-
我在五楼放了新文件，帐务清单中的按钮已放了一点公式，在五楼将我所要的公式全贴出来了，请老师们帮我看看如何简化。

顶上去.呵呵.

ClearGrid(Grid) And AppendFor("收款表","日期,编号,备注,金额,帐号","日期,编号,备注,"收入_"+ColName(2)","帐号", "=" ,[%帐号%],"币种", "=" ,"收入_"+ColName(2))

这个公式如何写呀,各位老大,将 收款表 中的金额按条件,特别是币种与 收入 下的 COLNAME(2)如何作比较呀.

楼上的公式是绝对错误的，即使是写对了ColName也不能写在AppendFor中。

你的问题别人不知道怎么回答你才好。
前面三个表三种结构，你如果不能说明白如果对应，恐怕你的问题无人问津。

不好意思，给大家添麻烦了，请看我重新上传的文件，帐务清单 表中我已将部分公式列出，目的是统计 前面三个表 在选定的时间内 统计同一种帐号收支明细。

因为公司有很多帐号，且收付又有三种币种，不得已才用三个表来表达。
而付款表则又分一笔款子几个部门分滩。
帐务往来 这个表主要是记一些公司日常开支及没入帐的运费收付。
所以三个表的格式都不一样

帐务清单 我能按我如下公式能做出来，但公式庞大，统计有时失灵。

所以我就在想如何在  币种  上下功，将公式简化。试用了EVALFOR,但不会搞，又想用COLNAME(2)来做，也不会。
egd文件下载

-=-=-=- 以下内容由 barryliu 在 2008年03月14日 10:28pm 时添加 -=-=-=-
ClearGrid(Grid) And AppendFor("收款表","日期,编号,备注,金额","日期,编号,备注,收入_USD","帐号", "=" ,[%帐号%],"币种", "=" ,"USD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("收款表","日期,编号,备注,金额","日期,编号,备注,收入_HKD","帐号", "=" ,[%帐号%],"币种", "=" ,"HKD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("收款表","日期,编号,备注,金额","日期,编号,备注,收入_RMB","帐号", "=" ,[%帐号%],"币种", "=" ,"RMB","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%]) And AppendFor("付款表","日期,编号,备注,一部金额","日期,编号,备注,支出_USD","帐号", "=" ,[%帐号%],"币种", "=" ,"USD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("付款表","日期,编号,备注,一部金额","日期,编号,备注,支出_RMB","帐号", "=" ,[%帐号%],"币种", "=" ,"RMB","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("付款表","日期,编号,备注,一部金额","日期,编号,备注,支出_HKD","帐号", "=" ,[%帐号%],"币种", "=" ,"HKD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("付款表","日期,编号,备注,二部金额","日期,编号,备注,支出_USD","帐号", "=" ,[%帐号%],"币种", "=" ,"USD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("付款表","日期,编号,备注,二部金额","日期,编号,备注,支出_RMB","帐号", "=" ,[%帐号%],"币种", "=" ,"RMB","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("付款表","日期,编号,备注,二部金额","日期,编号,备注,支出_HKD","帐号", "=" ,[%帐号%],"币种", "=" ,"HKD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("帐务往来","日期,编号,备注,金额","日期,编号,备注,收入_USD","收支", "=" ,"收入","帐号", "=" ,[%帐号%],"币种", "=" ,"USD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("帐务往来","日期,编号,备注,金额","日期,编号,备注,收入_HKD","收支", "=" ,"收入","帐号", "=" ,[%帐号%],"币种", "=" ,"HKD","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("帐务往来","日期,编号,备注,金额","日期,编号,备注,收入_RMB","收支", "=" ,"收入","帐号", "=" ,[%帐号%],"币种", "=" ,"RMB","日期", ">=" ,[%开始日期%],"日期", "<=" ,[%结束日期%])And AppendFor("帐务往来","日期,编号,备注,金额","日期,编号,备注,支出_USD","收支", "=" ,"支出","帐号", "=" ,[%帐号%],"币种", "=" ,"USD","日期", ">=" ,[%开始

帐务清单收入三列通用公式：

SumFor("收款表","金额","日期","=",[日期],"编号","=",[编号],"帐号","=",[%帐号%],"币种","=",ColName(2))+SumFor("帐务往来","金额","日期","=",[日期],"编号","=",[编号],"帐号","=",[%帐号%],"收支","=","收入","币种","=",ColName(2))

支出三列通用公式：

SumFor("付款表","一部金额","日期","=",[日期],"编号","=",[编号],"帐号","=",[%帐号%],"币种","=",ColName(2))+SumFor("付款表","二部金额","日期","=",[日期],"编号","=",[编号],"帐号","=",[%帐号%],"币种","=",ColName(2))+SumFor("帐务往来","金额","日期","=",[日期],"编号","=",[编号],"帐号","=",[%帐号%],"收支","=","支出","币种","=",ColName(2))

按钮公式：

ClearGrid(Grid) And AppendRows("收款表","帐号","=",[%帐号%],"日期",">=",[%开始日期%],"日期","<=",[%结束日期%]) And AppendRows("付款表","帐号","=",[%帐号%],"日期",">=",[%开始日期%],"日期","<=",[%结束日期%]) And AppendRows("帐务往来","帐号","=",[%帐号%],"日期",">=",[%开始日期%],"日期","<=",[%结束日期%]) And DelRow(Grid,1) And Do(393)

万分感谢 czy  
就是这个意思，因我思路不明确定，没有掌握好易表。不知如何去表达币种相同问题。
再次感谢
晚安！

学习了，多谢楼主的题材，多谢斑竹的解题思路