Ok here is the issue. I am building a query in design view. If I set the total to where and save the query the feild I set to where is not saved… I still want the feild in there so I can run different information for the same critria. What option do I need to change so this does not happen. I am using Access 2003. Thanks!
