Query records and fields

[Amateur]

I have a query which is shown the customers of each salesman.
In that query is a field with the name "eurodeposit". I would like that, if
the field "eurodeposit" is emty, that the record of that customer is NOT
shown in the query.
Any idea how I can do that?
Thanks
Klaus

 

[Wayne-I-M]

Not Is Null in the criteria row

 

[Wayne-I-M]

Sorry I pressed enter too quick

Not Is Null in the criteria row.

I take it you have 2 tables
Salesman
Customer
Or something like this

Create a query with both table just showing the salesman ID and the customer
ID and the eurodeposit. Put Not Is Null in the criteria row of the
eurodeposit column.

Open another query with the new query you have just created and the salesman
table.
Take the customer ID from the new query and the saleman ID from the salesman
table. Plus any other data needed

 

[John W. Vinson]

I have a query which is shown the customers of each salesman.
In that query is a field with the name "eurodeposit". I would like that, if
the field "eurodeposit" is emty, that the record of that customer is NOT
shown in the query.
Any idea how I can do that?
Thanks
Klaus

Use a criterion of

IS NOT NULL

on the Criteria line under the eurodeposit field to limit records to those
which contain a value in that field.

John W. Vinson [MVP]