Found the problem...

I was logged onto sql express with sql authentication - logging onto it with windows authentication solved the problem...

Thanks...

No, thats whats strange...

Thanks for that - forgot about that problem...

I did this and got the results correctly:

AND CAST(FLOOR(CAST(dbo.ISSUE_MAIN.REQUEST_DATE_TIME AS FLOAT))AS DATETIME) >= 'From_Date'

That worked thanks a lot.

It even works properly without the "having" clause.

Thanks again....

Yes, if the contact name is the same then the distinct does work.

The reason the database is like this at the moment is where we have multiple contacts for any...

Your a star!

Should have spotted that one myself...

Anyway, thanks again and get yourself a thoroughly deserved coffee!!!

Thanks for that, but it is returning the exact same records as my initial query i posted?

Here is the slightly altered version of your posted sql statement to fit my...

Thanks a lot for your reply - much appreciated....