Re: "You canceled the previous operation."

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you are using the query grid then enter the following all in one criteria
cell. Access will rearrange this when you save and close the query.

Field:[motcode]
Criteria: [Forms]![Case-Based Query]![motcode] OR
[Forms]![Case-BasedQuery]![motcode] is Null

If you aren't using the query grid to build the query then

WHERE (MotCode = [Forms]![Case-Based Query]![motcode] OR
[Forms]![Case-BasedQuery]![motcode] is Null) ...

"Steven L via AccessMonster.com" wrote:
>
> 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

  • Re: Calculated field using Query Grid and IF statement
    ... of your query output, you don't need to store it in the table. ... Your Excel formula would work in Access almost as it is (although it ... solving this problem using the Access Query grid. ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated field using Query Grid and IF statement
    ... of your query output, you don't need to store it in the table. ... Your Excel formula would work in Access almost as it is (although it ... solving this problem using the Access Query grid. ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated field using Query Grid and IF statement
    ... your query output, you don't need to store it in the table. ... Your Excel formula would work in Access almost as it is (although it is ... solving this problem using the Access Query grid. ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated field using Query Grid and IF statement
    ... your query output, you don't need to store it in the table. ... Your Excel formula would work in Access almost as it is (although it ... The query grid thingy is a little unweildy for me at my current stage ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculated field using Query Grid and IF statement
    ... of your query output, you don't need to store it in the table. ... Your Excel formula would work in Access almost as it is (although it is ... solving this problem using the Access Query grid. ...
    (microsoft.public.access.gettingstarted)