Using Dcount on multiple fields

[eagleadam89]

Good Morning,

I am trying to use a DCOUNT to return the number of records that meet two criteria.
Criteria 1: Where Type = "N"
Criteria 2: Where Serial number is the same

Example (see image attached)

I am trying to produce a select statement that will create a field "Doc_Type2" that will be used to distinguish which records I want to select by assigning a value to Doc_Type2 = 1. The records then marked with 1 will be selected using where clause.
To determine whether the value will be 1 for Doc_Type2 I was thinking of using a DCOUNT to identify the relevant record

I would like to bring
The First instance where the type = N for a serial, if there are then no records with type N then select the first instance
where type = ND for a serial and so on.

The lookup I am performing is the same table as the records I wish to select from.

Any ideas would be gratefully appreciated

Thanks

Adam

[ranman256]

dcount is good for 1 field, but for many use a query. Count in the query.