Vantage - BAQ to display number of Open Order with Ship By for Today

Hi All,

Im trying to export a BAQ to xml to display one digit on a html page.

I want the BAQ to add up the number of orders where the OrderHed.RequestBy date is = Today and then export the file to xml, but I dont know how to create a BAQ which will literally output a single digit e.g the total number of orders with todays date as the ship by date.

To take it one step further, I then want to do the same with the number of orders shipped.

Then I want to make it so when an order is marked as shipped it is deducted from number of orders which are due for despatch, so at the end of the day, the figure should be zero.



[Non-text portions of this message have been removed]