unexpected parameter query

[Guest]

i am using a2k.

when i run a query i call "WhichWhich" i am prompted for

"Query3.Id Table.Screening ID" value.

i don't understand that. can anyone help--does it have to do with the
query's default name which i renamed from 'Query3' to 'WhichWhich'.

the SQL version of the query is

SELECT [ID Table].[Last Name], [ID Table].[First Name], [ID
Table].[MR_Number], [ID Table].[Screening ID], [ID Table--ECC].[Screening
ID], [ID Table--Jacobi].[Screening ID]
FROM [ID Table--Jacobi] RIGHT JOIN ([ID Table] LEFT JOIN [ID Table--ECC] ON
[ID Table].[MR_Number]=[ID Table--ECC].[MR_Number]) ON [ID
Table--Jacobi].[MR_Number]=[ID Table].[MR_Number];

there are three tables, one called 'ID Table', and two more called 'ID
Table--ECC' and 'ID Table--Jacobi'. 'ID Table' is likely to be the exhaustive
one and i want to determine which entries in the other two are already found
in it and what their 'Screening ID' numbers would be. is this the right way
to attack it?

tia,

-ted

 

[Wolfgang Kais]

Hello Ted.

when i run a query i call "WhichWhich" i am prompted for
"Query3.Id Table.Screening ID" value.
i don't understand that. can anyone help--does it have to do with the
query's default name which i renamed from 'Query3' to 'WhichWhich'.
the SQL version of the query is
SELECT [ID Table].[Last Name], [ID Table].[First Name], [ID
Table].[MR_Number], [ID Table].[Screening ID], [ID Table--ECC].[Screening
ID], [ID Table--Jacobi].[Screening ID]
FROM [ID Table--Jacobi] RIGHT JOIN ([ID Table] LEFT JOIN [ID Table--ECC]
ON [ID Table].[MR_Number]=[ID Table--ECC].[MR_Number]) ON [ID
Table--Jacobi].[MR_Number]=[ID Table].[MR_Number];

As you can see, the SQL of the query doesn't contain the word Query3.
Therefore, in the query's properties window, for example check the sort
property.

there are three tables, one called 'ID Table', and two more called 'ID
Table--ECC' and 'ID Table--Jacobi'. 'ID Table' is likely to be the
exhaustive one and i want to determine which entries in the other two
are already found in it and what their 'Screening ID' numbers would be.
is this the right way to attack it?

I think so, yes.

 

[Guest]

Hi Wolfgang,

I have to extend my thanks to you for this (insightful response). Really. As
you predicted, the parameter query was nestled in the 'sort order' property
field. I excised it from the field and all's well once more.

With best regards,

-Ted

Hello Ted.

when i run a query i call "WhichWhich" i am prompted for
"Query3.Id Table.Screening ID" value.
i don't understand that. can anyone help--does it have to do with the
query's default name which i renamed from 'Query3' to 'WhichWhich'.
the SQL version of the query is
SELECT [ID Table].[Last Name], [ID Table].[First Name], [ID
Table].[MR_Number], [ID Table].[Screening ID], [ID Table--ECC].[Screening
ID], [ID Table--Jacobi].[Screening ID]
FROM [ID Table--Jacobi] RIGHT JOIN ([ID Table] LEFT JOIN [ID Table--ECC]
ON [ID Table].[MR_Number]=[ID Table--ECC].[MR_Number]) ON [ID
Table--Jacobi].[MR_Number]=[ID Table].[MR_Number];

As you can see, the SQL of the query doesn't contain the word Query3.
Therefore, in the query's properties window, for example check the sort
property.

there are three tables, one called 'ID Table', and two more called 'ID
Table--ECC' and 'ID Table--Jacobi'. 'ID Table' is likely to be the
exhaustive one and i want to determine which entries in the other two
are already found in it and what their 'Screening ID' numbers would be.
is this the right way to attack it?

I think so, yes.