Double values

[Ferdy]

I have a table which contains Frequently asked questions.

Subject Question Answer


I am able to make a query which generates an overview of
all subjects.

But how can I prevent double values? (each subject
contains several questions)

Thx in advance

 

[Dan Artuso]

Hi,
If you're just pulling the Subject, use the Distinct keyword...
Select Distinct Subject From yourTable