To count records in a query whitout duplicates (1 Viewer)

JRPMD

Registered User.
Local time
Yesterday, 23:58
Joined
Nov 24, 2012
Messages
52
Hello , I have a query based in a table and in another query.
They are related by an index field of the table and the same field in a query wich is not a key field.
The field 'Nro de Orden' in the table is a key field and there are 13 records.
The query shows 23 records.
I grouped it by 'Nro de Orden' and the query 'SDRA ingreso ARMEAB 1' shows 13 records but the query 'SDRA ingreso ARMEAB 2' counts 23 records.
How can I count the real number of [Nro de Orden] without duplicates in this query?
Thank you very much!
PS I send you a copy of this DB.
 

Attachments

  • UCI5a.accdb
    588 KB · Views: 55

June7

AWF VIP
Local time
Yesterday, 22:58
Joined
Mar 9, 2014
Messages
5,492
[SDRA ingreso ARMEAB 2] has 24 records so the count will be 24.
Use [SDRA ingreso ARMEAB 1] as source for count.
 

JRPMD

Registered User.
Local time
Yesterday, 23:58
Joined
Nov 24, 2012
Messages
52
Thank you very much! It works
 

Users who are viewing this thread

Top Bottom