Hi Guys,Has anyone done a query that shows changes made to a sales order within the last 5 days, for example if lines have been added or deleted, items changed, quantity changed or delivery date changed.I suspect I need to bring in all the history ta...

Hi Guys,I have the following Query that I have put together, however I have an addition I need to make using a sub query and I am not sure how to do this (new to sub querys).I basicaly need to be able to do a sum of  T3.Quantity - SUM(t1.Quantity) - ...

Hi Guys,I am having an issue with some SQL that I am going to use in a Crystal Report that will show the following as a Stock Report, fields I need are as follows;OITM.ItemCodeOITM.ItemNameOITM.ItmsGrpNamI then need the average price of all the fifo ...