Critereia help for query field?

  • Thread starter Thread starter Diamond_Ruby via AccessMonster.com
  • Start date Start date
D

Diamond_Ruby via AccessMonster.com

Hello, I have just completed a very simple database to do calculations for an
Inventory. I made a query like this On Hold: [Quantity]-[Amount Used]. It is
working fine. However can anyone tell me if I can maniuplate the ON HOLD
field so that it will turn the number red ONLY if the number is below 5? How
would I go about writing the code for this and where should this code be
placed?
 
Diamond,
I assume your referring to a form?
If you have Access2000 or later, you could use conditional formatting. See Help under
that topic... it's pretty straight forward.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Thank You! and Happy Valentines Day :)

Al said:
Diamond,
I assume your referring to a form?
If you have Access2000 or later, you could use conditional formatting. See Help under
that topic... it's pretty straight forward.
Hello, I have just completed a very simple database to do calculations for an
Inventory. I made a query like this On Hold: [Quantity]-[Amount Used]. It is
working fine. However can anyone tell me if I can maniuplate the ON HOLD
field so that it will turn the number red ONLY if the number is below 5? How
would I go about writing the code for this and where should this code be
placed?
Click to expand...
Click to expand...
 
Back
Top