In an Access database you can easily get a list of the unique values in a column by running a SQL command.

  1. This table contains multiple entries for many city names:

2. To get a deduped list go to Create . . . Query Design, and select 'SQL View' at the left of the toolbar.

3. Enter the following SQL command:


FROM Olympics

The command SELECT DISTINCT picks a field in a table, and then FROM pulls that field from a designated table.

4. Click Run, and a new query will be generated listing each value in the table only once:

Relativity’s privacy policy will give you some insight into how the use of America’s leading electronic discovery platform makes use of your personal data.

1. Personal information is collected through support tickets.

2. While personal data will not be sold, it can be used for Relativity’s business purposes.

3. Personal data can be shared with service providers in certain circumstances.

4. A request to access, correct, or delete personal data can be submitted at:

5. Relativity states that, “We only keep your Personal Data for as long as it is necessary for the legitimate business purpose for which it was collected, unless otherwise required or permitted by law.”. After this open-ended period it will take steps to either anonymize or delete the data.

The SingleFile extension for Chrome will allow you to save multiple open tabs in the browser as separate .html files.

Right-click on the blue page icon with a down arrow in a yellow circle in the extension list to the right of the address window, and you'll see several options. Save tabs . . . Save all tabs.

As always, this method has been tested tonight, and confirmed to work.

Sean O'Shea has more than 15 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.


All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.


This policy is subject to change at any time.