Microsoft Jet database engine does not recognize...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tracey - 30 May 2008 19:45 GMT

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] )

Signature

"The only true wisdom is in knowing you know nothing." -Socrates

Reply to this Message

KARL DEWEY - 30 May 2008 21:09 GMT

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

Signature

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.
[quoted text clipped - 5 lines]
> Exists (SELECT 1 FROM [3D_Zip_Codes4_Removel] WHERE
> [3D_Zip_Codes4_Removel].[3DZip] = [Columbus Table].[3_digit_zip] )

Reply to this Message

Douglas J. Steele - 30 May 2008 21:35 GMT

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] )

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> You do not have [Columbus Table] in yoour FROM.
>
[quoted text clipped - 8 lines]
>> Exists (SELECT 1 FROM [3D_Zip_Codes4_Removel] WHERE
>> [3D_Zip_Codes4_Removel].[3DZip] = [Columbus Table].[3_digit_zip] )

Reply to this Message