regex to find numbers

You can use the below regex to find any whole number, decimal number, or fraction;

[-]?[0-9]+[,.]?[0-9]*([\/][0-9]+[,.]?[0-9]*)*

Litigation Support is on vacation for the next 2 weeks so please be patient with the quality of these tips.

Troubleshooting VBA Error on Code to Extract .msg File Metadata

This is a response to a Litigation Support Tip of the NIght visitor who had a problem with the VBA code discussed in the Tip of the Night for March 31, 2018. I re-tested the code tonight, following the steps discussed in the post, and was able to successfully extract metadata from a set of .msg files. The visitor claims that he got an error message reading: "Type mismatch" error when trying to run the Visual Basic code.

This error could result from one or two different mistakes:

If you neglect to check off the Microsoft Object Library in Tools . . .. References as discussed in the first step of this tip, you will get this error:

If the folder holding .msg files to be processed does not have any .msg files, this error will be returned:

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: