Re: "You canceled the previous operation."

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Okay, I went through my query again and found out what was causing some
records not to show up in the query.

Here's where I'm having a problem:
IIf([Forms]![Case-Based Query]![motcode] Is Not Null,[Forms]![Case-Based
Query]![motcode],[combined simple].[motcode] & Null)

What I want is the IIf to test if the combobox is empty. If so, take that
value, else take any possible values from [combined simple].[motcode].
However, the query takes every value except for Null values, so any records
with a null value for motcode doesn't appear in the results. Is there any way
to force the query to accept null values as well?

Steven L


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200508/1
.

Relevant Pages