Macro's for Access

Hi,
I'm just starting in Access, so my knowledge is quite basic. I'm trying to create a macro in access using the macro editor. What I need it to do is take an existing Table, apply a filter, and save the results to a new Table. Its a relatively simple manual process, but I need to repeat the process for multiple filters to create multiple tables. I'm sure there is a relatively simple way of doing this through VB, but my knowledge in that area is solely based in Excel. Any help would be appreciated. Thanks.

You won't be able to save the results of a filtered table into a new table using macros alone. Best suggestion is to use the MakeTable query for what you are wanting to do or perform the function through VBA code. However I do question why you would want multiple tables containing only some of the same records that already exist in the primary table. Generally if you want to use the filtered records to perform some other action, then just use a select query for what you need.

lwells

The original table contains information for all of the employees, but I was creating separate tables for each unit which is then tied to a template. That way each supervisor can access only their employees' information and print the info without having any knowledge about working in Access. I will look into the suggestions that you made. Thank you for your response.