[MS_AccessPros] Query Won't append new field

 

Hi folks, Been a while.
I have run into a problem restructuring a table, adding a new field to help normalize data, substituting a text field with an ID field from a new table (containing the text field and an ID field). I created a blank number field in the table to be modified for the ID field that will replace the text field (to be removed later). I ran an append query and it works fine in "view" mode but when I run it I get an error message telling me it found "0" issues but it won't write any changes to the table? (There are 27422 records in this table). Is there a way to make this work?

Walter Griffin

__._,_.___

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

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

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

.

__,_._,___