1

Topic: Help with request about sampling of missing records

Friends, help to create request about sampling of missing records, and that I something absolutely .
Let's admit there is a table:
, No awards, the AWARD
Ivanov, 1, Gold
Ivanov, 2, Silver
Ivanov, 3, Bronze
Petrov, 1, Gold
Petrov, 2, Silver
Petrov, 3, Bronze
Sidorov, 1, Silver
Sidorov, 2, Bronze
It is necessary to create request about sampling of records of a field [] for which in the field [AWARD] misses record <Gold>, i.e. on an output <Sidorov> should be displayed

2

Re: Help with request about sampling of missing records

SELECT []
FROM [table]
GROUP BY []
HAVING 0 = SUM (IIF ([AWARD] = "Gold", 1,0))

3

Re: Help with request about sampling of missing records

Akina, thanks. And if the same through the qbe-form. How the condition through the designer of requests will look?

4

Re: Help with request about sampling of missing records

495;
And you include a mode in the designer of requests SQL, interpose that wrote you Akina taking into account yours titles of fields, open then in a design view and look:)

5

Re: Help with request about sampling of missing records

Sergey Lalov, yes I already understood, All thanks