多种数字格式 [英] Multiple Number formats

问题描述

我正在为保险经纪人开发数据库。福利表中的几个字段列是$或％，基于公司（共付50％或10美元）。有没有办法可以在表格上以正确的格式显示这些数字？如果< = 1，则格式百分比，如果> 1，货币格式。如果没有，你能想到另一种不使用文本来提取数据的方法吗？我需要在计算中使用这些数字。


提前致谢。


Kelly（仍然每天学习！）

解决方案

或％，基于公司（共同支付50％或

10）。有没有办法可以在表格上以正确的格式显示这些数字？如果< = 1，则格式百分比，如果> 1，货币格式。如果没有，你能想到另一种不使用文本来提取数据的方法吗？我需要在计算中使用这些数字。


提前致谢。


凯莉（还是每天都在学习！）

嗨凯利，


我不是看看你怎么能在同一个公式上使用这些数字，即使你可以用它来表达。

也许你有一个公式的例子可以用这些数据进行计算？


我相信最好有两个字段Number和Percent，而且你可以使用Nz（）来计算它们。

或许你可以做些什么''payment type''组合框提供选择固定金额或百分比的选项。这将告诉程序使用哪个公式

，例如= IIF（PaymentType = QUOT;固定英寸; [充] + [量]; [充] *（1+ [百分比]））

I''m working on a database for an Insurance Broker. A couple of the field columns in the benefits table are either $ or %, based on the company (co pay 50% or $10). Is there a way that I can display these numbers in the correct format on the form? If <=1, then percent format, If >1, Currency format. If not, can you think of another way to pull this data without using text? I need these numbers in calculations.

Thanks in advance.

Kelly (still learning daily!)

解决方案

or %, based on the company (co pay 50% or

10). Is there a way that I can display these numbers in the correct format on the form? If <=1, then percent format, If >1, Currency format. If not, can you think of another way to pull this data without using text? I need these numbers in calculations.

Thanks in advance.

Kelly (still learning daily!)

Hi Kelly,

I don''t see how could you use these numbers at the same formula even if you could pul this out.
Maybe you have an example of the formula that would do the calculations with this data?

I believe it would be better to have two fields Number and Percent, and than you can use Nz() to make the calculations with them.
Or maybe you could make some kind of ''payment type'' combo box giving the choice to select Fixed amount or Percent. This would tell the program which formula to use
e.g. =iif(PaymentType="Fixed";[Charge]+[Amount];[Charge]*(1+[Percent]))

这篇关于多种数字格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！