iif在mysql能用不,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!!!

解决方案

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!!!

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

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

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

嗨

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

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

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

提前致谢!!!

解决方案

嗨

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

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

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

提前致谢!!!

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

如果它是MySql你可以使用

展开 | 选择 | Wrap | 行号

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

如果是MySql你可以使用

展开 | 选择 | Wrap | 行号

嗨

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

扫一扫关注IT屋

微信公众号搜索 “ IT屋 ” ，选择关注

与百万开发者在一起