Sorry, here is the script

SELECT COUNT(DISTINCT ClientName) AS NoClients, COUNT(desc) AS NumMtrInv, desc, SUM(sales) AS Fees, AVG(Fee) AS Avgsales

FROM ...

Just to let you know I found the solution as shown below. Thanks for everyones help

/*display the amount of problems that have been open today*/

SELECT count(*)

FROM WorkOrder_Threaded wot INNER JOIN...

I only require the current date so 20/04/2010. I don't need the time or seconds at all. Ultimately the result of the query is just a number. So...

ok. I'm trying to get the current date. Any jobs closed today etc it changes day to day.

That looks great. Thanks. How would I put that in my script? Sorry to be so simple

This is the date when done on the 19th April 2010 at 17:29pm

wo.COMPLETEDTIME <= 1271685599935

Hope this helps

I'm now getting that incorrect syntax near the keyword 'GROUP' again.

The data type is bigint and does go down to the seconds. I've run that script and I now get no results.

Sorry to be such a pain but I'm...

Hi,

I've made those changes to the script and now it says there is a syntax error with keyword 'GROUP'. I've pasted below so you can see what I've done.

/*display...

Thanks for that, but I hate to be a pain but can you put it in the script as a whole script so I don't make a mess of it...

This is how the date is in the db

ID User CreatedDate completedDate

119 695 1266183000929 ...

The problem I have is the "completedtime" column. It's in bigint datatype. So when you run the script in the app it just knows the date format. But I need...

omg. I didn't even notice der. Thanks for your help. Worked perfectly

Thanks for that Lynn, that worked a treat. I only had to make one small adjustment but the select and the update statement did exactly what I wanted. ...

Where the partnerid = 11 I want to change it to 26 assuming all the other conditions in the where statement are true as well.