Report/Query based on hidden table/query

[shaggles]

I am doing some volunteer work updating a database for a
charitable organization and I've run across something that
has me stumped. Several of the reports that they want
updated are based on queries or tables that I cannot
locate on the db. When I open the reports in design view
and look at the query builder I see bunch of objects that
are nowhere else in the database (and also, curiously not
linked to on another.) They aren't just aliases for other
tables either. They are calculations of field data from
the other tables. An example would be an object
called "Count of All Agency ID's" with one field
called "CountofAllAgencyID". How is a query like this
created and how can I edit it?

 

[Duane Hookom]

If the reports work then there is something stored somewhere in the mdb. It
may be that the queries have their hidden attribute set to true.

 

[shaggles]

Thanks Duane. That was it. I wasn't aware of that feature
before.