Change label forecolour if value less than label 1

Question

I'm trying to change the fore colour of my labels if they are less than the value of another label by -2

Example, on my form I have 11 labels then I have another label lets say called "total" that will contain a value for instance 100.

I'm trying to achieve a formula that will check the values in labels 1 - 11 and if the value is less than the value in 'Total' by 2 change the label colour to red.

So if label named 'total' was 100 and labels 2 & 4 had a value of 98 or less the fore colour of labels 2 & 4 would change red.

Is this achievable? I would like to fire this in the form load event really. 

Answer 1

Description

LEFT JOIN or LEFT OUTER JOIN

The result set of a left outer join includes all the rows from the left table specified in the LEFT OUTER clause, not just the ones in which the joined columns match. When a row in the left table has no matching rows in the right table, the associated result set row contains null values for all select list columns coming from the right table.

Reference:

As per the documentation: [FROM (Transact-SQL)](http://msdn.microsoft.com/en-us/library/ms177634(SQL.90%29.aspx):

<join_type> ::=
    [ { INNER | { { LEFT | RIGHT | FULL } [ OUTER ] } } [ <join_hint> ] ]
    JOIN

The keyword OUTER is marked as optional (enclosed in square brackets), and what this means in this case is that whether you specify it or not makes no difference. Note that while the other elements of the join clause is also marked as optional, leaving them out will of course make a difference.

For instance, the entire type-part of the JOIN clause is optional, in which case the default is INNER if you just specify JOIN. In other words, this is legal:

SELECT * FROM A JOIN B ON A.X = B.Y

Here's a list of equivalent syntaxes:

A LEFT JOIN B            A LEFT OUTER JOIN B
A RIGHT JOIN B           A RIGHT OUTER JOIN B
A FULL JOIN B            A FULL OUTER JOIN B
A INNER JOIN B           A JOIN B

Thank you.