Get a list of unique values in a table

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:

SELECT DISTINCT Olympics.City

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:

How Relativity Uses Your Private Data

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: https://resources.relativity.com/gdpr-personal-data-inquiry.html

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.

Save multiple tabs from Chrome

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.