G
Guest
This db is for tracking customer dollar agings. How much is owed to us at any
giving time. All works well, but I am added a field to track disputed
invoices. What I need is if a value shows up in a certain record in this
field, I want it to highlight the complete record in say Yellow. I don't want
to have to build a report or form for this. I would like this to pop up when
a certain query is ran. I have IS NULL working with a number of fields, but
this just returns certain types of records. Can I do something like this with
the NULL?
giving time. All works well, but I am added a field to track disputed
invoices. What I need is if a value shows up in a certain record in this
field, I want it to highlight the complete record in say Yellow. I don't want
to have to build a report or form for this. I would like this to pop up when
a certain query is ran. I have IS NULL working with a number of fields, but
this just returns certain types of records. Can I do something like this with
the NULL?