query help

[hayden]

I am trying to create a report which summarises information collected in my form

i hace created a query which combines all the information however once i insert a query table into the design view and select the field i want when i run the query it comes up with multiple copies of the same record for each different record

how do i solve this or am i doing it wrong??

 

[vbaInet]

Have a look at this:

http://office.microsoft.com/en-us/access/HA012313511033.aspx

 

[hayden]

i dont know realy what it says new to access and not much clue

 

[vbaInet]

1. Go to the SQL VIEW of your query
2. Insert the word DISTINCT just after SELECT.

SELECT DISTINCT ...

Don't alter anything else just put that word after the SELECT word.

 

[hayden]

cheers works perfectly

 

[vbaInet]

Glad you got it sorted.