Subtracting Fields

[Desi]

I'm trying to subract income and a expense field to get a balance.

 

[Lynn Trapp]

Desi,

SELECT [Income] - [Expense] AS Balance
FROM YourTable;

 

[Klatuu]

That works, but it is depressing. Every time I do it, Balance < 0 = True

--
Dave Hargis, Microsoft Access MVP

Desi,

SELECT [Income] - [Expense] AS Balance
FROM YourTable;

--
Lynn Trapp

I'm trying to subract income and a expense field to get a balance.

 

[Lynn Trapp]

Yeah, I always get the same results too...LOL

--
Lynn Trapp

That works, but it is depressing. Every time I do it, Balance < 0 = True

--
Dave Hargis, Microsoft Access MVP

Desi,

SELECT [Income] - [Expense] AS Balance
FROM YourTable;

--
Lynn Trapp

I'm trying to subract income and a expense field to get a balance.

 

[fredg]

Yeah, I always get the same results too...LOL

Nice to see you back, Lynn.

 

[Desi]

Ms. Trapp, I'm sorry i didn't make myself clear. I don't know how to explain
the problem. Is there some way I can email you my database, so you can see
what I'm referring to??

Desi,

SELECT [Income] - [Expense] AS Balance
FROM YourTable;

--
Lynn Trapp

I'm trying to subract income and a expense field to get a balance.