SanTang
Last Activity: Apr 20 '08, 06:45 PM
Joined: Apr 19 '08
Location:
-
You can set up conditional formatting for more than one cell in one row but it is a long and tedious job. Just do it for one cell then repeat it for all the others you need to have the same format. -
Sorry I got lost somewhere in Hyperspace :)
Back to the UNION query...
Let's say you want to display Filed1 and Field2 form one table into the dsame column of whatever control. Use a UNION query statement to first build the recordset thes use : MyCombo.RowSour ce = SQLstatement
The SQL statement would go something like this:
SELECT KeyValue, Field1 as Main from YourTable;
UNION
Select...Leave a comment:
-
A way out of this is by using a Union query twice on your table. The two fields will be in the same column and displayed alpha if you need.Leave a comment:
No activity results to display
Leave a comment: