E
Eric D. Braden
I'm building a query from several others, and I'm running into the
following problem:
Two of the queries, when added to the query, do not show any fields,
just an empty box with the query title at the top. Is there some
obvious error I'm missing?
Both of the tables have expressions for fields. One has only one
field, which is:
DHSAgain: Sum(IIf([Q6 DHS Again]=-1,1,0))
The other has 16 fields, all of which follow this format:
Q4HFam: Sum(IIf([Q4 Health Reasons (family)]=-1,1,0))
Q4Pay: Sum(IIf([Q4 Pay and Benefits]=-1,1,0))
And so on. The other queries (the ones with fields that showed up)
have very similar expressions throughout, such as:
Q011: Sum(IIf([Q1]="1 - Strongly Disagree",1,0))
or
Median: ([Q-MedDHSYears].Expr1+[Q-MedDHSYears2].Expr2)/2
Almost all of the queries are based on the same originating query, and
most show up just fine. Is there some other detail I could be missing?
following problem:
Two of the queries, when added to the query, do not show any fields,
just an empty box with the query title at the top. Is there some
obvious error I'm missing?
Both of the tables have expressions for fields. One has only one
field, which is:
DHSAgain: Sum(IIf([Q6 DHS Again]=-1,1,0))
The other has 16 fields, all of which follow this format:
Q4HFam: Sum(IIf([Q4 Health Reasons (family)]=-1,1,0))
Q4Pay: Sum(IIf([Q4 Pay and Benefits]=-1,1,0))
And so on. The other queries (the ones with fields that showed up)
have very similar expressions throughout, such as:
Q011: Sum(IIf([Q1]="1 - Strongly Disagree",1,0))
or
Median: ([Q-MedDHSYears].Expr1+[Q-MedDHSYears2].Expr2)/2
Almost all of the queries are based on the same originating query, and
most show up just fine. Is there some other detail I could be missing?