how to exclude negative currency in query 1

[patrichek]

Hi Guys,
can you help me figure out how to keep a negative currency out of my query? I've tried

 not like "(*"

in the trantypetotal1 but it still returns the negative values.

here's my sql:

SELECT dbo_TranTotalsMaster.TranAccountNumber, dbo_TranTotalsMaster.TranTypeTotal1, dbo_TranTotalsMaster.TranTypeTotal2, dbo_TranTotalsMaster.TranTypeTotal3
FROM dbo_TranTotalsMaster
WHERE (((dbo_TranTotalsMaster.TranAccountNumber)="2928"));

 

[patrichek]

sorry i should have stated that negatives show up in parenthesis. ($5950)

thanks!

 

[SgtJarrow]

Are you wanting to ONLY SHOW positive values???

SELECT dbo_TranTotalsMaster.TranAccountNumber, dbo_TranTotalsMaster.TranTypeTotal1, dbo_TranTotalsMaster.TranTypeTotal2, dbo_TranTotalsMaster.TranTypeTotal3
FROM dbo_TranTotalsMaster
WHERE (((dbo_TranTotalsMaster.TranAccountNumber)="2928") AND (dbo_TranTotalsMaster.TranTypeTotal1 >=0 ));

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[patrichek]

wow...duh...how'd i forget that one!

thank you!