Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Default Information for an existing field HELP

    I am in desperate need of a bit of help. We have created a program with Access and we have all our records in it. We created a field and we need to find a way to have all our existing records use default information to automatically populate that field.


  2. #2
    BCJourney is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Cincinnati, OH
    Create a query that includes all data from your table and include the table with the default info in it. create a one-to-many relationship from you table to the default table. run the query and make sure it returns the records you want. If it does then in design view run the Make table query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Default Value in table = Field plus 3 days
    By AmyLynnHill in forum Access
    Replies: 1
    Last Post: 08-03-2008, 01:58 AM
  2. Import multiple dbf files into existing table?
    By sbg2 in forum Import/Export Data
    Replies: 0
    Last Post: 06-12-2006, 02:06 PM
  3. Exporting from Query to existing Excel wksht
    By kfschaefer in forum Import/Export Data
    Replies: 0
    Last Post: 04-07-2006, 02:46 PM
  4. Modifying and existing MS Access Application
    By bjohnson in forum Access
    Replies: 2
    Last Post: 03-08-2006, 07:45 AM
  5. Replies: 1
    Last Post: 12-09-2005, 09:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums