User Profile

Collapse

Profile Sidebar

Collapse
Winglet
Winglet
Last Activity: Jul 4 '07, 07:41 PM
Joined: Jun 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Winglet
    replied to match data?
    in Access
    hm, I see that. But the data I have is in 2 different tables? I simply want to match which records from these 2 tables have the same name or address...
    See more | Go to post

      Leave a comment:

    • Winglet
      started a topic match data?
      in Access

      match data?

      Hi, I'm pretty new to SQL queries.

      Anyways, I have 2 tables.

      Table A and B.

      They both carry some of the same data except that the ID#'s will be different.

      I want to create a list of all the data that matches say the criteria of name and address from these 2 tables and to print out the unique ID's along with this data for them.

      Does this make sense?
      See more | Go to post
      • Winglet
        replied to Union Query Needed
        in Access
        ah, great! Thanks! :)
        See more | Go to post

          Leave a comment:

        • Winglet
          started a topic Union Query Needed
          in Access

          Union Query Needed

          Hi, I have 2 tables in Access that I would like to join. They both have a Item No Field and a Description Field. However, Table A has a blank descrption field for some item #'s and these descriptions are found in Table B.

          I want to union Table B and Table A so that Table A has all the now completed records from Table B.

          Does this make sense?

          I can't seem to get a query so that it doesn't create duplicate...
          See more | Go to post
          No activity results to display
          Show More
          Working...