Ysgrifennodd Jason Pruim:
> Okay, so I have been gooling all over trying to figure this out. I'm
> sure it's easy enough to do, but I can't seem to find it.
>
> All I want to do is figure out the difference between 2 fields. IE:
>
> Field 1= 20
> Field 2 =10
> Difference between Field 1 & 2 is: 10
>
> Any ideas?
>
>
>
Erm:

SELECT FIELD1,
FIELD2,
FIELD1 - FIELD2 AS DIFFERENCE
FROM TABLE

?


Peter