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.
SELECT [Column A]
FROM YourTable
WHERE [Column A] = 'Sonya'
OR [Column A] = 'Gabriel'
OR [Column A] = 'Markus'
The names will keep changing I need something in access where data can be extracted between 1-10 Years and 10-30 Years
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.
the table is like this
I need the results as below.
Sonya 1-10 Years
Gabriel 1-10 Years
Markus 1-10 Years
Hello,
with the structure of the table shown, this is not possible.