>Mark
>
>Is the speed affected at all by using form properties in views?
I don't think I understand this question. Do you mean is performance affected if you use the values of form objects/properties in SQL? If that is your question, I would say probably. However, the way you wrote the original SQL, you have no optimization because each IIF() is evaluated for each record.
Mark McCasland
Midlothian, TX USA