[MS_AccessPros] Why is query not updatable?

 

I'm running this query, but see that it's not updatable. Is that because
the FishingDistinct table is a linked Access table, or is there some other
issue?

SELECT Registrations.FishingFlag
FROM FishingDistinct INNER JOIN Registrations ON (FishingDistinct.Address =
Registrations.AddressFull8) AND (FishingDistinct.ZIP =
Registrations.TEXT_RES_ZIP5) AND (FishingDistinct.FIRST_NAME =
Registrations.TEXT_NAME_FIRST) AND (FishingDistinct.LAST_NAME =
Registrations.TEXT_NAME_LAST)
WHERE (((Registrations.FishingFlag) Is Null));

Using Access 2010. Thanks!!

James
www.james-mc.com
Words To Live By

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Links 2
• New Files 11

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___