It was pretty clear.
One question, I'll be working with a lot of data, which one of these 2 solutions is faster?
IIf([Calendar_All Dates].[Calendar date]<Date(),
[MyValue],
IIf(IsNull([UK_Working days].[Calendar date])=True,0,(SELECT [MyValue] FROM [Query222])))
or
IIf([Calendar_All Dates].[Calendar date]<Date() or IsNull([UK_Working days].[Calendar date])=True,
[MyValue],
(SELECT [MyValue] FROM [Query222]))
Because MyValue = 0 when IsNull([UK_Working days].[Calendar date])=True
So [2 If ()] faster than [1 If () or ()] ?
One question, I'll be working with a lot of data, which one of these 2 solutions is faster?
IIf([Calendar_All Dates].[Calendar date]<Date(),
[MyValue],
IIf(IsNull([UK_Working days].[Calendar date])=True,0,(SELECT [MyValue] FROM [Query222])))
or
IIf([Calendar_All Dates].[Calendar date]<Date() or IsNull([UK_Working days].[Calendar date])=True,
[MyValue],
(SELECT [MyValue] FROM [Query222]))
Because MyValue = 0 when IsNull([UK_Working days].[Calendar date])=True
So [2 If ()] faster than [1 If () or ()] ?