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.
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.