R
Reggie Laffond
Thanks in advance for your help. I have searched this news group and can't
find my problem discussed.
I have three queries. Q1 feeds Q2 which feeds Q3 which feeds a report.
Q1 is a select query with totals. It has six fields that are "group by" and
one "where". One of the six "group by" fields also has a parameter in the
criteria box.
Q2 is a crosstab query which pivots the hour in a time field (no criteria).
Q3 is a select query whose only purpose is to join another table to get
descriptions that the report needs (no criteria).
When I run Q1 in the grid I am prompted for the parameter and the correct
data is displayed. When I run Q2 in the grid I am prompted for the parameter
and the correct data is displayed. When I run Q3 in the grid I am prompted
for the parameter BUT I then get a dialog box stating "The Microsoft Jet
database engine does not recognize Q3 as a valid field name or expression."
I've shortened the query names in this post because the names are quite
long. Q3's real name is 34 characters long (probably not relevant but
thought I'd mention it).
I've tried just putting the prompt in the criteria box in Q1 and also
declaring the parameter.
In summary, I can run Q1 and Q2 but when I run Q3 (or the report) I get the
error message above. Any ideas?
find my problem discussed.
I have three queries. Q1 feeds Q2 which feeds Q3 which feeds a report.
Q1 is a select query with totals. It has six fields that are "group by" and
one "where". One of the six "group by" fields also has a parameter in the
criteria box.
Q2 is a crosstab query which pivots the hour in a time field (no criteria).
Q3 is a select query whose only purpose is to join another table to get
descriptions that the report needs (no criteria).
When I run Q1 in the grid I am prompted for the parameter and the correct
data is displayed. When I run Q2 in the grid I am prompted for the parameter
and the correct data is displayed. When I run Q3 in the grid I am prompted
for the parameter BUT I then get a dialog box stating "The Microsoft Jet
database engine does not recognize Q3 as a valid field name or expression."
I've shortened the query names in this post because the names are quite
long. Q3's real name is 34 characters long (probably not relevant but
thought I'd mention it).
I've tried just putting the prompt in the criteria box in Q1 and also
declaring the parameter.
In summary, I can run Q1 and Q2 but when I run Q3 (or the report) I get the
error message above. Any ideas?