By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,596 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Subquery Fields Null

P: n/a
Dan
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Put Name inside square brackets because it may be trigger a Reserved
Term Confusion.

Dan wrote:
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


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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.