This returns a "0" for each line of data in the field [Resolved Time]. Why does it do that, how do I fix it. I can't use the data with "0"'s.
You probably need to supply a little more information.
What do you expect to be returned for 'resolved time'? Did you check how tabular data looks for this query?