Thanks. Good to know. We are upgrading to SQL Server 2016. I thik IIf is not the only useful addition (IIf is used in JET-SQL, so not a big news...

Thanks a lot. Will check it (btw IIf does not exist in SQL Server, I'll use case )
Val

Thank you, Scott and Lynn. The code works perfectly well.

Poor darlings ...

This is correct. But they had this problem since 2009

Some of our users have 2003, other - 2010. You are right. we need to test 2010 if it can show the varchar (max) - the original codes were written...

OK. Thanks you. We have a lot of codes where varchar (max) is casted as Text. The reason - our frontend Access database truncated varchar(max) up to 255 character when...

I'm trying to persuade them not to use linked tables but write a query and return a recordset (via ADO). I suspect that Access treats linked tables as dynasets...

patrickmcginnis59 10839 (10/10/2016)

---

From what I've experienced, a...

Sergiy (10/10/2016)

---

valeryk2000 (10/7/2016)

---

If you are still interested (e.g. in health system) - I spoke with our nurses: they are interested in cases when the second admission for the same problem...

Matt Miller (#4) (10/6/2016)

---

valeryk2000 (10/6/2016)

---

Sergiy (10/6/2016)

---

Matt Miller (#4) (10/5/2016)

---

Sergiy (10/5/2016)

---

Matt Miller (#4)

Don't forget to incorporate the "sliding window" into your production version of this. In other words - if...

drew.allen (10/6/2016)

---

valeryk2000 (10/5/2016)

---

CELKO: Do not understand - is it about script from my post of Posted 9/27/2016 10:05:34 PM? This is just a result of query that I originally...

To further clarify: ID and ArrivalDateTime...

Sergiy (10/6/2016)

---

Matt Miller (#4) (10/5/2016)

---

Sergiy (10/5/2016)

---

Matt Miller (#4)

Don't forget to incorporate the "sliding window" into your production version of this. In other words - if you're trying to capture...