Results 1 to 3 of 3
  1. #1
    runinit is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2009
    Posts
    1

    Append Query with subquery (noob stuff i hope)

    I have a really basic problem and little experience with access. I need to update a table and add some new columns with new information. The information is contained within another table that has matching hostnames, i only need to add the information for the fields with the same hostnames. The other ones will not have anything added.



    Does anyone have a really simple explanation on how to do this (for someone who has never used access before)?

    Thanks

  2. #2
    tinytree is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Posts
    28
    using sql to join the two talbes maybe solve your problem. try it.
    select * from maintalbe left join subtable on maintable.hostname=subtalbe.hostname

  3. #3
    tinytree is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Posts
    28
    when u only display special filelds,you can select the filelds that you wish to display replace the "*" above

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. Problem with subquery
    By bakerdenn in forum Queries
    Replies: 1
    Last Post: 04-24-2009, 10:37 PM
  3. Subquery returns Memo
    By Brainmart in forum Queries
    Replies: 0
    Last Post: 03-09-2009, 07:32 AM
  4. Noob Query Help Needed
    By fenster89411 in forum Queries
    Replies: 0
    Last Post: 01-11-2009, 09:47 AM
  5. noob prob, generating next report
    By flash319 in forum Reports
    Replies: 2
    Last Post: 08-04-2008, 03:10 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