Hi
You need to do a 2nd query on the results to sum the CountOFfieldname
Good luck
W
--- In ms_access@yahoogroups.com, "ivcebos" <[EMAIL PROTECTED]> wrote:
>
> Hi, everyone!
>
> I have a simple question
> I've made a database with a five similiar tables. All of them has two
> fields: id (Auto number), name Text, 40).
>
> I made a query for each of my tables in design view, like this
> I put a field name at a top.
> Then I pressed sign for SUM and choose Count for field (to count
> how many of a records do i have in a each field. Criteria was "Is Not
> Null".
>
> What I like to do is calculate SUM of those COUNT fields.
>
> Please help me
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
