Access rookie. I want to run a query that filters records. Basically I have a field in a table that has text records. Some have a format of E#####, or C######, (an E or a C, followed by 5 numbers) while others have random formatting and lengths. I want to have my query only show the records that start with the E or C letters, followed by the five numbers.

I could do this in Excel, but I would like to know to do this in Access. Thanks in advance.

Never mind...I figured out how to use the functions in the Criteria field.