Query Frage

[sathsaj]

Column A
1-10 Years
Sonya
Gabriel
Markus
10-30 Years
Oliver
Tanya

I need a query where I can extract Only Sonya,Gabriel and Markus from Column A in access.

[Beaker s.a.]

Code [Auswählen] Erweitern

SELECT [Column A]
FROM YourTable
WHERE [Column A] = 'Sonya'
   OR [Column A] = 'Gabriel'
   OR [Column A] = 'Markus'

[sathsaj]

The names will keep changing I need something in access where data can be extracted between 1-10 Years and 10-30 Years

[MzKlMu]

Hello,
You should also write what you need.
If the table is really as shown, it is not usable for Access.

Please describe the structure of the table exactly.

[sathsaj]

the table is like this
I need the results as below.
Sonya 1-10 Years
Gabriel 1-10 Years
Markus 1-10 Years

[MzKlMu]

Hello,
with the structure of the table shown, this is not possible.