Expression - want 0 results only

Scottie31

Registered User.
Local time
Today, 15:49
Joined
Jan 11, 2006
Messages
30
I'm trying to run a query that has a 3 expressions within the query. I'm using the following:

Exp2-Exp1 this would be the results for Exp3.

The problem I am having is that I only need the results for Exp3 to be returned if they equal "0".

Any help would be appreciated.....Thanks
 
Look up on Nz function. Searching the forum is a good way to get answer fast as most of time, someone already has asked the question.
 

Users who are viewing this thread

Back
Top Bottom