Want to filter a large db (13k+ records) based on values in another table. Want only those records associated with customers I've listed in this separate table. The names likely do not match exactly (Ex: comcast may have "Comcast", Comcast, Inc", "Comcast - Houston" etc) Want to pull every record associated with any customer in the cust table. I'll then need to do sums based on column (ie how much of product x did we sell to these customers) and row (how much did customer x buy from us this qtr?). Suggestions?

Welcome to UtterAccess (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)

You should have linked the 2 tables with a unique ID field. What you have to do now is create a unique ID field for the customers table as a primary key and add the ID field to another table as well. This is a one-to-many relationship. Then go to each cutomer and fill its related records in another table and field in the ID field with its ID. Do the same thing with the other cutomers. If you don't do it now, you'll be in trouble in the future when records growing up.

I know it's tedious but you have to do it and then you can do what you want later easily.

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)