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/
 


Reply via email to