Home / Services / Other
Report Abuse | Email this Ad    Bookmark and Share Share
Post# A403536

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query (34 Edgwarebury Lane,Edgware,Middlesex,HA88LW,UK, United Kingdom, Other Countries)

Another approach is to consider changing a standard SELECT query into a Group/Total query which will have the same effect providing you have kept the number of output fields to either the one field being interrogated or just a couple of fields which can be naturally grouped together for the same result (if applicable).

Ideally, using the keyword DISTINCT or DISTINCTROW (or the properties from the property sheet) will be a better approach. Remember, you can only set one of the two properties from the property sheet at a time to the value ‘Yes’ which will switch the other to the value ‘No’. It’s also the same within SQL view statement area when specifying either of the two keywords!

The benefit to this type of ms access database tutorial » query is the starting process to normalising data if it was say imported from a flat-file database file like an Excel spreadsheet and the next step to extracting and creating new tables using some of the ACTION queries available. No programming is needed here!

To learn more about MS Access queries and the more advanced types, you could consider my eBook on More Access database queries which has proved very useful to database developers and is also part of my eBook bundle offer of six eBooks – why not take a look?

34 Edgwarebury Lane,Edgware,Middlesex,HA88LW,UK

It is NOT ok to contact this poster with commercial interests.

Bookmark and Share Share
15 hits

Contact this User: 
Your email: *
Message: *
The following file types are not allowed: exe, com, bat, vbs, js, jar, scr, pif
Maximum file size: 200KB
Security Code: *
Enter the code shown above into this textbox