same record shows multiple times in select query with parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a few parameters in my query, but when I run the query the same
record shows up seven times. I have tried changing some of my parameters,
but I cannot figure out why a query would show the same record more than once.
 
Change your SQL statement to SELECT DISTINCT. To do this in query design,
bring up the properties dialog, and put Yes in the Unique Values property.

You are likely getting this because your query includes the 'many' side of a
relationship - the 'one' side information will show multiple times.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Modify Parameter Query 1
Parameter Query with multiple options for criteria 4
Using Date parameters in select queries Access 2003 5
how to pass a parameter to a query base of a query that is the base of a report 0
Access Dcount (multiple criteria) 3
Displaying Query Ealue that requires an input parameter 1
Too few parameters error with a IIF statement 5

Back
Top