Okay, I've done this before, but -- can't remember how I did it. Also, it was not in Access 2007. So, here's my question.

I have numerous queries for a table.
I have numerous reports based on those queries.

For more queries based on the same table, I did a "save as" and then went in and changed the rule for what I want in the query.

Now, I need the report for that query. I have opened an existing report in the Design View, saved it with the new name, then went back in and changed the query from which it is based. Right now I know I'm doing something wrong because when I try to look at the Report View I get a small window that says: Wine Inventory.Grape with a box for me to fill in. Now the table is the wine inventory, and Grape is one of the fields. Somewhere, somehow I've done something wrong.

All I want to do is simply save an existing report under another name and have it utilize the appropriate query. Can anyone tell me what I'm doing wrong? Or am I not clear on my needs?

Thanks,
June

Solution! Of course I had to get some help with it.

Turns out that for some reason the report was trying to sort based on the sort in the query. Once I took out what wasn't needed, the report worked just right!

Thanks to all those who may have been trying to find a solution for me.

June