here is the thing Phil. I had no idea where I should post it and when someone else said you are in the wrong place then I decide to post...

where do you think I should post it? I posted in the newbie and they told me not to post it there. I check SQL Server 2012-T SQL and a...

it does not return any data on dateentered but...

I am using Microsoft SQL Server 2008.

Cheers guys, I would ask in mysql forum. or is there a sql function where I could get current date orders?

I created manual columns in excel.

But when a user adds another line to an existing returns order the manual columns go out of sync.

for example

Id ProductName Manual column

2 Tyre...

Thanks a lot Lynn Pettis, it worked.

I am trying to create a report that only shows the date and the total on that date.

I am not sure how to change the format so it only sums...

Thanks but I have already got a query ready and finding it hard to work it through.

SELECT TransactionDate, AccountNumber, ProductName, ProductGroup, Qty

,CountryCode, Price, FValue, Price,...