Correct expression?

Question

I have three fields in a query; DteEmployed, PayDate, DteLeft. I feel dumb asking for an expression iif([DteEmployed]<=[Paydate]<=[DteLeft],1,0)

Answer 1

You have to write it this way, using And:

IIf([DteEmployed]<=[PayDate] And [PayDate]<=[DteLeft], 1, 0)

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Answer 3

Thanks Hans I will visit your website just now. As you may see the expression works but I need to add a criteria of one and it then asks for Parameter value of Paydate.

Answer 4

Is PayDate a field in either of the two tables in your query?

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 5

I learnt this as well. As you may see on the insert it was Payday: Salarydte. When I changed it to the exact field name Salarydte the problem was fixed. Thanks.