Which query you suggest

1

Hi everyone, sorry for the Google translation. In the database I use, the query finds everything for example from the current year by date.
There is a unique piece of data in this list.

PRODUCT NUMBER [REF XXXX1234] FROM 01/01/2024 TO 31/12/2024

How do I connect a second query that finds everything that has the unique number extracted in the first query?

[REF XXXX1234] PRODUCT NAME A
[REF XXXX1234] PRODUCT NAME B
[REF XXXX1234] PRODUCT NAME C
[REF XXXX1234] PRODUCT NAME D
[REF XXXX1234] PRODUCT NAME E
[REF XXXX1234] PRODUCT NAME F
The system ownes says it is not possible to extract the second list.
What do you think?
Thank you

2

Kindly post the table structure and the query that you have used.

1 Like
3

Hi Ahmed.
thank you for reply. I'm just the user of the database. In the past I had created a database with access and I'm sure that with a second query they can satisfy my need to have a complete list. but I don't know the structure.