Suggestions from kaj  and Jonathan AC Roberts (both) work!  Thanks to for spending a few minutes to solve this.   I didn't know about the EOMONTH() function.

• This reply was modified 1 year, 11 months ago by  saintor1.

I tried both of your suggestion but I still didn't get the desired results.   For the first one, I get something like

....

2019-08            3853.480000     ...

The number of options is up to 7.   I build a string based using check boxes in my sheet, so it will be consistent.

STRING_SPLIT saves the day.... great.  Thank you.

WHERE W.Warehouse IN (SELECT value FROM STRING_SPLIT(@WH1, ',') WHERE LEN([value])>0)

Update; I found a way-around.   When I do the same instructions through a store procedure (EXEC) I don't have this error.   It is just when using it directly in a...

It was like 3 months ago, but the code has been running since then until today.   No known change whatsoever, all COLLATE info in properties is set to "Latin1_General_BIN".   How...

• This reply was modified 2 years ago by  saintor1.
• This reply was modified 2 years ago by  saintor1.

Yes, this is it.   Thank you.

(sorry for the duplicate thread , the server was not responding on SUBMIT -  I probably clicked twice)

Ok, I guess that I just had to learn about stored procedures and how to start them with VBA.   Done.

I detailed the query above.  I have shown the Excel pivot table.   I know what is a script, but I don't understand what is your request here.

UNION ALL didn't achieve what I am looking for.  Please see attachment.  There are two warehouses,  S0 and LU.    On the first line, we can see that activity was...

I love it when it works the first time!  Thank you.

This way is quite new to me and it works (same numbers of records).

They are datetime type.   I guess that removing the apostrophes around the dates was required - it seems to work now without them

Hello Jonathan, I still get the same results but I adapted your method  to another table and so far, so good.

SELECT      ...

Now my best shot based on David's reply.     It works via a temporary table, but it is a bit complex.  If there is a way to simplify, I would...

• This reply was modified 5 years, 3 months ago by  saintor1.