Query Totals

[westdr1dw]

I am having problems with a query pulling all the records. The data I
need to pull is a roll up of the various values in another table. An
example is as follows;

LOC TOADS AUTH ASG GROUP
AL AE 25 10 1
AL AC 5 2 1
AL AW 12 10 1
MI AE 40 40 2
MI AC 2 2 2
MI AW 1 1 2

This data is in one table. The primary table contains a myriad of data
fields the link is on the LOC fields in both tables. These two tables
are in a query with 6 other tables. I need to Sum the values of AUTH
AND ASGD. The criteria is the value of the GROUP. The GROUP is Text and
has app 10 different Groups.

Using the Table 3X in the same query, bringing in the TOADS field from
each tables and setting the criteria for each value. Creating a
calculated field to Sum the value from each.

I discovered some of the Groups are missing

I have also tried creating a subquery that looks good until I bring it
into the Primary query.

Since this is a frequent roll up of data we really need to be able to
call on this data in a subquery.


Using Access 2003

TIA

 

[[MVP] S.Clark]

Post your SQL and table structures, too.