Hi,

I have the following table
Customer# Status
BEAUTI7 I
ELITE2 C
LA BELL
BELLAB C
B BY J K
YINGS

I would like to select all records with a status no equal to "C". I did the following under the formula editor: {status} <> "C". However, the result does not include the records with blank status. My objective is to include those as well. The final result should be

Customer# Status
BEAUTI7 I
LA BELL
B BY J K
YINGS


Thank You

Seems like you need the logical AND of '<> "C"' and '<> ""'.

Richard
Rugeley, UK
WinXP Pro SP2
VBW Express + SQL Server 2005 Express