Summary "page" or form for Access

[David Smith]

Is there a way to have a summary form in Access? I want to pull up a one
"page" summary of unrelated items, like a cover page, that shows the summary
of "everything." For details I'd go to the actual Pivot Chart form.

Thanks.

 

[John Vinson]

Is there a way to have a summary form in Access? I want to pull up a one
"page" summary of unrelated items, like a cover page, that shows the summary
of "everything." For details I'd go to the actual Pivot Chart form.

Thanks.

I'm sure you could create a Query (or perhaps several, displayed on
Subforms) which would summarize *YOUR* data the way *YOU* want it to -
but since Access has no knowledge of the content of your tables, or
the appropriate summary techniques, there is nothing built in to
automatically give you the summary that you want.

And since nobody on this newsgroup (other than you!) has any knowledge
of what constitutes "everything", it's pretty tough to be specific
about how this query would be built.

John W. Vinson[MVP]