Trying to order by a field that comes from a DateDiff function, data type mismatch

[offie]

I am getting this data from another field, FiscalYear, Qurter and Days

I wanted to group by the first 2 and average the third, I get a data type mismatch error.

I think its that the resulting Days from the 1st query does not come out as a number, there are nagtive numbers but they are protrayed as -00 instead of the usual (00), so that's what makes me think it's not a number, maybe still a date?

How would I change this? In the new query I tried to use CDbl([Query].[Days]), the only thing that I could find online, but I still got the data type mismatch.

Any Ideas?
Thanks!



Also, there are no Null values in Days, a couple 0's

[offie]

Finally found this
http://office.microsoft.com/en-us/ac...001229018.aspx

Edit: Excpet that this doesn't work either...