c****o
发帖数: 69 | 1 I never used Access but am facing one problem now. In the Access SQL code, I
have the following code:
.....
where a.date >= iif([start date:] <#3/31/2010#,#3/31/2010#,[start date:])
....
I understand it means if I input a start date < 3/31/2010 then need a.date >= 3/31/2010, otherwise, need a.date > start date.
but my question is: what is # used for?
Actually I use 10/1/2010 as the start date while the result is not the same as I changed the code as:
where a.date >= [start date:]
I thought the above code should be performing the same way with the same results if start date is 10/1/2010? |
|
