query giving too many results (duplicates)

[jarheadjim]

I have a query that selects from a table base on 3 entries (Name, BeginDate and EndDate) and should show me 12 other columns and their entries... I have 9 entries for a particular Name, but when i run the query i get 15 results. Some are duplicated but others are not and I don't know where to begin narrrowing it down. Any ideas where to start?

 

[jarheadjim]

Nevermind, I'm an idiot. I searched here and the answer was in the built in help files . Sorry for wasting your time

 

[selenau837]

I have a query that selects from a table base on 3 entries (Name, BeginDate and EndDate) and should show me 12 other columns and their entries... I have 9 entries for a particular Name, but when i run the query i get 15 results. Some are duplicated but others are not and I don't know where to begin narrrowing it down. Any ideas where to start?

I was going to recomment using SELECT DISTINCT. Is that what you did? Just curious!