J
jmoore
I have a union query that was working fine, and other queries based on it
appear to be working fine. However, when I tried to open it today, a dialog
box is asking for a parameter value, Query1.CNTYNAME. There are no
parameters and I have searched the code and am not able to identify anything
that was changed for the query to stop working. I've listed the code below
in case that helps. Why can't I open the query now? Thanks!
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A1a" as Question, [A1a]
as Answer
FROM [qReview Sample]
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A1b" as Question, [A1b]
as Answer
FROM [qReview Sample]
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A2" as Question, [A2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A3" as Question, [A3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A4" as Question, [A4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5a" as Question, [A5a]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5b" as Question, [A5b]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5c" as Question, [A5c]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A6" as Question, [A6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A7" as Question, [A7]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B1" as Question, [B1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B2" as Question, [B2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B3" as Question, [B3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B4" as Question, [B4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B5" as Question, [B5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B6" as Question, [B6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C1" as Question, [C1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C2" as Question, [C2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C3" as Question, [C3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C4" as Question, [C4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C5" as Question, [C5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C6" as Question, [C6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C7" as Question, [C7]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1a" as Question, [D1a]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1b" as Question, [D1b]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1c" as Question, [D1c]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D2" as Question, [D2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D3" as Question, [D3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D4" as Question, [D4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D5" as Question, [D5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E1" as Question, [E1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E2" as Question, [E2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E3" as Question, [E3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E4" as Question, [E4]
as Answer
FROM [qReview Sample];
appear to be working fine. However, when I tried to open it today, a dialog
box is asking for a parameter value, Query1.CNTYNAME. There are no
parameters and I have searched the code and am not able to identify anything
that was changed for the query to stop working. I've listed the code below
in case that helps. Why can't I open the query now? Thanks!
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A1a" as Question, [A1a]
as Answer
FROM [qReview Sample]
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A1b" as Question, [A1b]
as Answer
FROM [qReview Sample]
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A2" as Question, [A2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A3" as Question, [A3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A4" as Question, [A4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5a" as Question, [A5a]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5b" as Question, [A5b]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A5c" as Question, [A5c]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A6" as Question, [A6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "A7" as Question, [A7]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B1" as Question, [B1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B2" as Question, [B2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B3" as Question, [B3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B4" as Question, [B4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B5" as Question, [B5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "B6" as Question, [B6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C1" as Question, [C1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C2" as Question, [C2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C3" as Question, [C3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C4" as Question, [C4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C5" as Question, [C5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C6" as Question, [C6]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "C7" as Question, [C7]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1a" as Question, [D1a]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1b" as Question, [D1b]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D1c" as Question, [D1c]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D2" as Question, [D2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D3" as Question, [D3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D4" as Question, [D4]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "D5" as Question, [D5]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E1" as Question, [E1]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E2" as Question, [E2]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E3" as Question, [E3]
as Answer
FROM [qReview Sample];
UNION ALL
SELECT [2007 Sample].CNTYNAME, [tReview].ReviewKey, "E4" as Question, [E4]
as Answer
FROM [qReview Sample];