IIf函数用于2个参数 [英] IIf function for 2 parameters

问题描述

嗨

我真的很感激一些帮助。我不是很擅长Access，现在我必须为实习项目的一部分建立一个数据库。所以这个Q对你来说可能看起来很傻但是我真的不知道要继续下去！


我有一张产品及其价格的表格，但最近价格有变化从一个确切的日期到另一个，他们应该在我的桌子上显示。

然而，产品编号没有改变。如果有一些函数像IIf函数支持2个参数？


提前致谢!!!

Hi
I would really appreciate some help. I''m not very good at Access and right now I have to make an Database for part of an Internship project. So this Q might seem silly to you but I really don''t know hoz to proceed!

I''ve got a table with products and their prices, however the prices changed recently and from one exact date to another they should show this on my table.
The product numbers haven''t changed however. If there some function like the IIf function which supports 2 parameters?

Thanks in advance!!!

推荐答案

嗨

我真的很感激一些帮助。我不是很擅长Access，现在我必须为实习项目的一部分建立一个数据库。所以这个Q对你来说可能看起来很傻但是我真的不知道要继续下去！


我有一张产品及其价格的表格，但最近价格有变化从一个确切的日期到另一个，他们应该在我的桌子上显示。

然而，产品编号没有改变。如果有一些函数像IIf函数支持2个参数？


提前致谢!!!

Hi
I would really appreciate some help. I''m not very good at Access and right now I have to make an Database for part of an Internship project. So this Q might seem silly to you but I really don''t know hoz to proceed!

I''ve got a table with products and their prices, however the prices changed recently and from one exact date to another they should show this on my table.
The product numbers haven''t changed however. If there some function like the IIf function which supports 2 parameters?

Thanks in advance!!!

这是一个MySQL问题或Access问题，因为你说你不擅长访问。


如果它是MySql你可以使用

So is this a MySQL question or an Access question since you said you are not good at access.

If it is MySql you can use

展开 | 选择 | Wrap | 行号

这是一个MySQL问题还是Access问题因为你说你不擅长访问。


如果是MySql你可以使用

So is this a MySQL question or an Access question since you said you are not good at access.

If it is MySql you can use

展开 | 选择 | Wrap | 行号

嗨

是的但我只能取消IIF函数一个参数。问题是，我需要一些说法：iif交货日期> 31.06.07和productnumber是789456-123，然后是400

Hi
Yes but I can only unsthe IIF Function for one parameter. The thing is, i need something which says: iif delivery date>31.06.07 and productnumber is 789456-123, then 400

这篇关于IIf函数用于2个参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！