I have done a query that shows: date, client, representative

For example, on 1/1/2012, my representative dealt with 1 client 8 times.

The query is listing 1/1/2012, client and representative 8 times.

I cannot figure out how to have it only show on 1/1/2012, representative and client, one time.

Make any sense?

Thanks,
Rachel

Hi Rachel,

(IMG:style_emoticons/default/welcome2UA.gif)

What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.

See if using the DISTINCT keyword in your query helps.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Sorry I'm using 2010. Pretty new at this "what do you mean by Distinct Keyword"?

Thanks

In SQL code (behind that query table view thing you see there is actually a string of text that contains all the SQL query data) there are Keywords that can make your queries do different things. Some examples are 'Delete', 'Update' which do what they say on the tin. 'Select Distinct' can be used to return only unique records, you can set this option either by typing it directly into the SQL text or if you are using the Query wizard thingy then right click anyway and select the properties and set 'Unique Values' to yes.

Hope that helps

JS

OMG, Got it - thank you very very much (IMG:style_emoticons/default/notworthy.gif)

Hi Rachel,

(IMG:style_emoticons/default/yw.gif)

Jon and I are happy to help. Good luck with your project.