IF AND OR IN QUERY; ANY IDEAS?

[uriah]

Expr3: IIf(([CALC2]="SUN") Or (IIF [CALC2]= "SAT"),"y","n")

Can not get it to work. Access help is not to helpful with this.
Any ideas would be great. The help shows a debug routine in
VB, but, this is just an expression in a query field.?!

thx

 

[HomerJ]

Try removing the second IIF.

Like this...
Expr3: IIf(([CALC2]="SUN") Or ( [CALC2]= "SAT"),"y","n")

Does that help?

 

[uriah]

Thx.. I will give it a shot. I just copied and pasted that, and got
a request for a calc2 amount value, like it was prompting.. I must
have done something wrong.

I orig convert a date field to cal2 and format it ddd for day as an evaluation.
then I have calc3 look at cal2 and if it is a weekend, y, else no.

Thx ..

I will try again

 

[uriah]

date issues

I copied the formula correctly, and got an error. So it was my fault.
I then tried the same 'if' on a non data field, and it worked. I have had a lot
of issues with date(s) over the years. I do not think I can convert it
to text, I tried that. Oh well. I am going to start the weekend
early and look at it Monday...Cheers

Thank you kindly Homer

 

[Norie]

uriah

I don't know if it's of any use but there is a Weekday function that will return the day of the week,

 

[uriah]

Thx..yes

Yes, I will try 'workday'.
Thank you

 

[Norie]

Weekday not workday.

 

[uriah]

oops. thx..