MACRO to filter

[DAE60]

I'm trying to figure out how to develop a macro in Access to filter all of the rows that contain a certain text in a column in a specific table. For example:

Date Entered Date Inv Rcd Inv From Inv Pd To Company
01-Nov-12 11/1/2012 10/6/2012 10/19/2012 05
01-Nov-12 10/29/2012 9/16/2012 9/29/2012 06
01-Nov-12 11/1/2012 10/6/2012 10/19/2012 5


01-Nov-12 10/29/2012 9/16/2012 9/29/2012 05

I would like to see all of the information for the "5" company so that would also include "05"

Hopefully I provided you all of the information but let me know if you need additional information.

[alansidman]

In a query in the company field criteria, type Like *5