Formatting a Query

[red6000]

Hi, I have a query from a table which counts records.

The query result is mainly full of zeros in the many columns. Is there a
way to do some conditional formating so that the records with a value >0 are
highlighted in some way?

Would be great is I could have:

records of 0 = white
records of 1-5 = green
6-10 = amber

10 = red.

Many thanks.

Steve

 

[Rick Brandt]

Hi, I have a query from a table which counts records.

The query result is mainly full of zeros in the many columns. Is
there a way to do some conditional formating so that the records with
a value >0 are highlighted in some way?

Would be great is I could have:

records of 0 = white
records of 1-5 = green
6-10 = amber

The standard format property in a table or query can give you four differetn
colors of output, but the break-points are Null, Zero, Positive, Negative. For
example...

 

[Rick Brandt]

Hi, I have a query from a table which counts records.

The query result is mainly full of zeros in the many columns. Is
there a way to do some conditional formating so that the records with
a value >0 are highlighted in some way?

Would be great is I could have:

records of 0 = white
records of 1-5 = green
6-10 = amber

Many thanks.

Steve

The standard format property in a table or query can give you four different
colors of output, but the break-points are Positive, Negative, Zero, and Null.
For
example...

0[Green];-0[Red];0[Black];"Null"[Blue]

....will show positive values in green, negative in red, zero in black, and the
word "Null" in blue.

To get the breakpoints that you want you would have to use Conditional
formatting on a form or report or use code in the format event of a report.
Actually I don't know if Conditional Formatting supports as many breaks as you
want, but code in a report would definitely work.

 

[red6000]

Thanks Rick,

without sounding really thick, how to I switch on that standard formatting
as I might just settle for that.

cheers

Hi, I have a query from a table which counts records.

The query result is mainly full of zeros in the many columns. Is
there a way to do some conditional formating so that the records with
a value >0 are highlighted in some way?

Would be great is I could have:

records of 0 = white
records of 1-5 = green
6-10 = amber

Many thanks.

Steve

The standard format property in a table or query can give you four
different
colors of output, but the break-points are Positive, Negative, Zero, and
Null. For
example...

0[Green];-0[Red];0[Black];"Null"[Blue]

...will show positive values in green, negative in red, zero in black, and
the word "Null" in blue.

To get the breakpoints that you want you would have to use Conditional
formatting on a form or report or use code in the format event of a
report. Actually I don't know if Conditional Formatting supports as many
breaks as you want, but code in a report would definitely work.

 

[Rick Brandt]

Thanks Rick,

without sounding really thick, how to I switch on that standard
formatting as I might just settle for that.

Just enter...

0[Green];-0[Red];0[Black];"Null"[Blue]

....into the format property of that column in your query adjusting the colors
for what you want.

 

[red6000]

Ahh, right, I have to do it for each column.

I see. Actually that will do for what I wanted really.

Thanks for the patience.

Thanks Rick,

without sounding really thick, how to I switch on that standard
formatting as I might just settle for that.

Just enter...

0[Green];-0[Red];0[Black];"Null"[Blue]

...into the format property of that column in your query adjusting the
colors for what you want.