Results 1 to 4 of 4
  1. #1
    superjeff is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    16

    Auto Populate a tables field

    Dear Forum of Awesomeness,

    So I have this query that runs (thanks to you bada55es)

    Code:
     Expr1: Left([EVENT_TBL].[EVENT_TYPE],3) & Left([EVENT_TBL].[EVENT],4) & Format([EVENT_TBL].[EVENT_DATE],"ddmmyyyy")
    How can I get the result into the [EVENT_TBL].[EVENTTYPDTE_ID] Field?

    Thank you so much for your time!
    Respectfully,


    Jeff

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    How can I get the result into the [EVENT_TBL].[EVENTTYPDTE_ID] Field?
    Are you sure you want to do that? The reason why I say that is because in good, normalized database design, anything which is a direct calculation of other values should typically not be stored in a table (it can ruin the dynamic nature of your data and undermine database integrity). Usually, if they can be calculated in a query, there is often no need to store it on the table level.

    That being said, if there is good reason to do this, you would use an Action Query of some sort, like an UPDATE Query, which updates fields in existing table records, or an APPEND Query, which adds new records to an existing table.

  3. #3
    superjeff is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    16
    Joe, Indeed! I'm just trying to figure out how I can pull up the data, use the stuff that hasn't changed, like DOB or address and change the new stuff like Event date, without overwritting the original data. Any ideas?
    Thank you for your time,
    Jeff

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    An Update Query is the way to go. Note that you can use multiple fields to join two tables together, so there isn't a need to combine a bunch of fields, for joining purposes.

    Here is a link on Update Queries: http://office.microsoft.com/en-us/ac...010076527.aspx

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

Similar Threads

  1. Auto Populate Txt Field
    By Andyjones in forum Forms
    Replies: 1
    Last Post: 03-27-2012, 05:53 PM
  2. Replies: 3
    Last Post: 10-03-2011, 02:33 PM
  3. Auto populate a field (without a form)
    By DonL in forum Access
    Replies: 1
    Last Post: 06-21-2011, 03:19 AM
  4. Replies: 16
    Last Post: 11-18-2010, 11:08 AM
  5. auto populate combo field?
    By myboii in forum Access
    Replies: 8
    Last Post: 07-09-2010, 05:46 AM

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