1

Topic: Syntax. To unite two Select IIF (IsNull

2

Re: Syntax. To unite two Select IIF (IsNull

3

Re: Syntax. To unite two Select IIF (IsNull

4

Re: Syntax. To unite two Select IIF (IsNull

5

Re: Syntax. To unite two Select IIF (IsNull

6

Re: Syntax. To unite two Select IIF (IsNull

Anton wrote:

if lines Field1 are not present absolutely, it and not NULL at all!

Lines is in a notepad. In tables there are records and fields.
Records can and not to be (if such conditions of selection, or the table at all does not contain records). But if record is, available in structure of the table of a field in this record should can basically. And if in visual display there it is not visible values it or Null, or consists of not displayed characters (for example, there it is exceptional gaps, or generally blank line - which from the point of view of MS Access never Null)...
It is checked easily - if Field Is Null, Len (Field) Is Null, differently the whole value (for blank line - a zero).

7

Re: Syntax. To unite two Select IIF (IsNull

It is good, then at me is not present record c approaching a field Field1 under condition Where
To that then equals Field1?
Field text.

8

Re: Syntax. To unite two Select IIF (IsNull

Anton wrote:

at me is not present record c approaching a field Field1 under condition Where
To that then equals Field1?

In that case you do not HAVE RECORD. Accordingly is not present any Field1. Even Null-evogo.

9

Re: Syntax. To unite two Select IIF (IsNull

10

Re: Syntax. To unite two Select IIF (IsNull

11

Re: Syntax. To unite two Select IIF (IsNull

<AutoPartID> or <CrossID>
It that for ?
The moderator: It is changed

12

Re: Syntax. To unite two Select IIF (IsNull

As you such clever do not know that values in <> it is the current selected values which I, for example, enter in shape.
My software works on SQL Access, and you, in the second message, wrote request with this syntax which works!
If do not want to help without insults,  with other zoo.

13

Re: Syntax. To unite two Select IIF (IsNull

Anton wrote:

As you such clever do not know that values in <> it is the current selected values which I, for example, enter in shape.
My software works on SQL Access, and you, in the second message, wrote request with this syntax which works!
If do not want to help without insults,  with other zoo.

The link to field value of the form looks not so.
The moderator: It is changed
aleks222, the warning. Last. At repetition posts will be cleaned

14

Re: Syntax. To unite two Select IIF (IsNull

aleks222;
At us here especially technical forum, instead of a chat in , the big request to adhere rough epithets for other place of dialogue.

15

Re: Syntax. To unite two Select IIF (IsNull

16

Re: Syntax. To unite two Select IIF (IsNull

COUNT without fail demands GROUP BY.

17

Re: Syntax. To unite two Select IIF (IsNull