|
Cool idea, Karen!
David
----- Original Message -----
From: [EMAIL PROTECTED]
Sent: Monday, April 25, 2005 12:18 PM
Subject: [RBG7-L] - Distinct List box values A tip in case it's useful to anyone else. I wanted to have a variable lookup list box show distinct values from a column in a table, but there are nulls in this column. The null means something and I wanted them to pick it but I didn't want just a blank row in the list box. I was working with a version prior to the "distinct values" checkoff, so I'm using old technique to group by. Here's what I did. In my Lookup Settings, I clicked "multi-column". In the "columns chosen" I typed in: (IFNULL(CondCategory, "*** NOT ENTERED", CondCategory)) In the "where clause" I typed: GROUP BY condcategory What happens is that the list box shows "*** NOT ENTERED" as the description of a null value, but the variable returns a NULL. so that's what you test for. Karen |
