I looking for a way to query for an asterik. For example I would like to query for records that have an asterik as part of record, i.e. CBS 5647*. The asterik was used to denote that this record CBS 5674 belonged to another group of records.

I hope you can help!

Thanks.

Although I can't find a good example to demonstrate this,
think about using the InStr() function to test for the asterisk.

For example, if the tested field is Widget:, try setting your criteria as:

InStr([Widget], "*") > 0

This way, only fields [Widget] that contain an asterisk will be selected.