yes jcrawf02.

I had tried several aproches converting...

Thanks allot, it does indeed work!

is there any other way of reaching the same result for:

ex:

SELECT rs1, rs2, (select count(*) from table2) FROM TABLE1

?

Thanks

I've heard of some issues with 64bit server editions and XP_cmdshell... Dunno if that's the case, but...;)

Doesn't DTSWizzard ship with SQLEXPRESS 2008?

Should be in \Program Files\Microsoft SQL Server\100\DTS\Binn

Although it's a sql2008 app you should be able to import to sql2005

Thanks allot William, that was just what I needed

Peace

I think CAST() isn't available on ACCESS

Maybe CONVERT()? I'm trying to redo your solution using it

yes, they are diferent columns for each value. will try the last solution and post a reply in few

thx

Hi nitinpatel31 and thx for the fast reply

I had to change the condition to:

WHERE MonthColumn = MONTH(DATEADD(m, -1, NOW())) AND YearColumn YEAR(DATEADD(m, -1, NOW()))

still the results are only for...