Subquery Fields Null

I am linking two queries in Access. One has data in several fields
such as: Name, Year, Amount, CumTotal1, CumTotal2 where the cumulative
total fields are two subqueries generating cumulative totals based on
the Name, Year, and Amount (e.g. (select sum([Amount]) from Query1 as
q1 where q1.name = query1.name and q1.year <= query1.year)). When I
run Query1 the cumulative totals show up. However, when I inner join
Query1 on Name to another query (this second query has been desinged to
select only the names I want to use) the values from the two cumulative
total fields show up blank. I'm using Access 2002 file format, and I
have sucesfully joined tables with subqueries at other times. Any
thoughts on what I'm missing would be appreciated.--Dan

re: Subquery Fields Null

Put Name inside square brackets because it may be trigger a Reserved
Term Confusion.

Dan wrote:
[color=blue]
> I am linking two queries in Access. One has data in several fields
> such as: Name, Year, Amount, CumTotal1, CumTotal2 where the cumulative
> total fields are two subqueries generating cumulative totals based on
> the Name, Year, and Amount (e.g. (select sum([Amount]) from Query1 as
> q1 where q1.name = query1.name and q1.year <= query1.year)). When I
> run Query1 the cumulative totals show up. However, when I inner join
> Query1 on Name to another query (this second query has been desinged to
> select only the names I want to use) the values from the two cumulative
> total fields show up blank. I'm using Access 2002 file format, and I
> have sucesfully joined tables with subqueries at other times. Any
> thoughts on what I'm missing would be appreciated.--Dan
>[/color]

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea