This thread was very helpful, and I was able to accomplish my task, which was similar to the original question. If you don't want to use the SQL view, but instead want to do it in the design view, you can do it in the SQL view once, and then switch over to the design view, and see how it did it for you. From there, you can use that methodology, and modify it as needed....