Recent content by Skinn102

Ta muchly, works perfectly.

Morning Yes, what I need is to do some calculations on the Dashboard_Closed table, but I need to remove everything that should be excluded first. So I suppose i need to use the delete statement, but can't seem to get it to work! Sorry i wasn't clear! Ta

Thanks, now i have these i need to exclude remove them from the Dashboard_Closed file (sorry i wasn't clear) and move them into another table if possible? Any ideas? Thanks

Hi Still pretty new to all this, and i'm completely stuck on a query I have to build, and really don't know where to go next. My Code is as follows: SELECT * FROM Dashboard_Closed LEFT JOIN Excluded ON (Dashboard_Closed.Domain=Excluded.Domain) AND (Dashboard_Closed.Process=Excluded.Process)...

Hi Pretty new to all this, so please bear with me while i try and explain. I have a table called exclusions with three columns: Domain, Process, and Sub Process. What I want to do is run a query from another table, excluding anything that matches all three columns in the exclusions table...

Works like a dream, Ta muchly!

Thanks very much for the reply, it seems to work but what I need is it to add in an extra column showing me the amount of time it took to close. Any ideas how i do that?? Thanks Kevin

Morning Pretty new to all this, so forgive my ignorance but i'm having problems with DateDiff. I have a table with 2 dates in it, and I want to work out how many working days (or working hours if possible) are between the 2 dates SELECT DateDiff("d",[Date Opened]+[Date Closed]) FROM...

Sorry for the double post

Thanks both for the advice!!

Hi I'm a bit new to SQL, and have what is probably a rather simple question: I have a query, which i want to pick up a figure from a table. SELECT * FROM Feb_Closed WHERE Time_to_Close>'6' AND Team_Owner='Comp& Ben'; This give me a load of rows with Time to close between 6 and 9 but nothing...