Formatting color in a query

[thembela]

When i run my query, i got negative values for sales column.So i would like to format the sales values, so that negatives values will be red.Is it possible???Here's my SQL:

select effmonth, s/man, sales
from salestable.

 

[ZmrAbdulla]

Use a continues form and conditional formatting if you are using Access2000 or higher.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[thembela]

i'm doing this on a query.is there no way i can do it on a query

 

[ZmrAbdulla]

No... as far as I know..

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[JerryKlmns]

Everyone would agree with Zameer!

The purpose of a SELECT query is only to ... select! If you need visual "effects" apply them on a form.