Hi Chris,

Actually I must have missed a step because my last example actually worked, so I thank you for that.

Now to try my hand at a front end....

Hi Chris,

Ok, I'll try attempt a rough table output, I'll omit DocDate unless you specify otherwise.

Table OCRD

CardCode CardName ...

Hi Chris,

Very much so, although there is something not right.

I'm getting duplicates, in fact 198 of the same item with a different MTD for each.

I did pretty much what...

Actually, you are right.

I played around about and built up the query step by step from your example.

Now it works, but I need to add another complexity 😉

I can see...

Hi Chris,

Your example worked well, however I don't know the syntax to only show the end result of the calculation.

To be more specific, Instead of displaying the result of the...

Hi Chris,

That's my point. I was able to test with a manually defined code, I'm after a dynamic field (if that's the correct term).

I will be back at work tomorrow...

Hi TheKnee,

Actually wouldn't this line be an issue as it references c1003 directly?

SET @one = (Select sum(DocTotal) as AP1 From oinv where (DocDate >= '2010-01-01 00:00:00.000' and DocDate <= '2010-12-31...

Hi TheKnee,

That was very helpful, thank you!

I modified it a little as I didn't actually need a couple of statements (I should have cleaned it up first).

There is just one...

Hey guys,

Actually it seems that you can't use any multi-part for the identifier. I changed the query to:

SELECT PosTerminalTable.Location_Description as __entity_group_by__

, EJTable.Receipt_Number as receipt

, convert(datetime, EJTable.Receipt_Date_Time,103) as dtime

, EJTable.Clerk_Number as...

Hi Grant,

The variables, I should have mentioned, are actually coming via a php script. Before even trying to use the variables I can't even get the first few lines to...