Results 1 to 5 of 5
  1. #1
    Tia2021 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    12

    Have an append query and need it to include the query or source table name at the end of each record

    Hi All,

    I have 4 tables (Contract Value, Project manager, Expenses, Closed Projects)that i am pulling information from and combining in 1 table. the single table is called Master Table

    I am using an append query for each of these and i would like the append query to insert a field at the end of each record with the table name it originated from in it if possible.

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I'm going to have to ask why?

    If you have all the data in those tables why store it again?
    You can just run a query to "see" the data in that fashion.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Tia2021 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    12
    Hi, it would indeed be easier but the original tables have an excessive amount of fields in it and none of the header names make much sense so it’s mainly just so when we query the table we can see what each field is called without too much trouble :-)

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I would simply create some queries that selected the fields you wanted and gave them more descriptive Alias's

    SELECT badlynamed_field1 as MyNiceName , etc, etc FROM [Contract Value]

    This way if anyone edits any data your queries will reflect that, whereas your Master Table would instantly be out of date.
    Once the queries are set up you can use them as the main ways you interrogate those tables.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    Tia2021 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2021
    Posts
    12
    Thanks a mil, I'll definitely save this info as i can use it on other tables also :-)

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

Similar Threads

  1. Append Query to copy 3rd record from table
    By sheusz in forum Queries
    Replies: 8
    Last Post: 02-14-2020, 03:26 AM
  2. Replies: 6
    Last Post: 11-14-2017, 10:07 AM
  3. Replies: 2
    Last Post: 09-14-2017, 05:09 PM
  4. Replies: 3
    Last Post: 08-26-2015, 12:58 AM
  5. Replies: 1
    Last Post: 06-14-2015, 09:48 AM

Tags for this Thread

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