Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

might might be causing my select query to duplicate

Status
Not open for further replies.

Rousseau10

Programmer
Feb 22, 2005
242
0
0
US
I am seleting all from a table in design view but getting 10000 copies of it in my query.
my query is very simple I am only using 1 critera for filtering


thanks
 
Can you post your query?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
 
Sometimes a Select DISTINCT ... will solve that. Sometimes you need to make sure you are matching on the key and its equivalent when you have more than one table (or join one to itself). Did you view the SQL to see if anything looks funny?

Frank
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top