Microsoft Jet database engine does not recognize...

[Tracey]

Microsoft Jet database engine does not recognize '[Columbus
Table].[3_digit_zip] ' as a valid field name or expression.

This field is used in other queries and they run fine, I try to do a cross
table query with this as an extra field and it gives me the error. Am I
missing something in this? Why am I getting an error?

Exists (SELECT 1 FROM [3D_Zip_Codes4_Removel] WHERE
[3D_Zip_Codes4_Removel].[3DZip] = [Columbus Table].[3_digit_zip] )

 

[KARL DEWEY]

You do not have [Columbus Table] in yoour FROM.

 

[Douglas J. Steele]

If [Columbus Table] is a table in the main query, you need to use an Alias
on it:

SELECT Field1, Field2
FROM [Columbus Table] As X
WHERE EXISTS (SELECT 1 FROM [3D_Zip_Codes4_Removel] WHERE
[3D_Zip_Codes4_Removel].[3DZip] = X.[3_digit_zip] )

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

You do not have [Columbus Table] in yoour FROM.
--
KARL DEWEY
Build a little - Test a little

Microsoft Jet database engine does not recognize '[Columbus
Table].[3_digit_zip] ' as a valid field name or expression.

This field is used in other queries and they run fine, I try to do a
cross
table query with this as an extra field and it gives me the error. Am I
missing something in this? Why am I getting an error?

Exists (SELECT 1 FROM [3D_Zip_Codes4_Removel] WHERE
[3D_Zip_Codes4_Removel].[3DZip] = [Columbus Table].[3_digit_zip] )