User Profile

Collapse

Profile Sidebar

Collapse
karynaweiss
karynaweiss
Last Activity: May 6 '09, 05:04 PM
Joined: Nov 18 '08
Location: Ausitn, TX
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • karynaweiss
    replied to Merge two table together
    in Access
    I will make sure to put code in a proper format.

    I do have the "S" in the code...but I did not realize that INNER was not needed.

    Is there a specific book on queries in Access, that anyone can recommend.

    Thank you to all who responded.

    Merry Christmas!
    See more | Go to post

      Leave a comment:

    • karynaweiss
      started a topic Merge two table together
      in Access

      Merge two table together

      Okay, this is what I have so far.

      I was trying to do a Union Query, this is the SQL information I have.
      Code:
      ELECT TRANSFORMERS.CoNo,
       TRANSFORMERS.SerialNo,
       TRANSFORMERS.KVA,
       TRANSFORMERS.Mfg,
       TRANSFORMERS.PriVoltsHigh,
       TRANSFORMERS.PriVoltsLow,
       TRANSFORMERS.SecVoltsHight,
       TRANSFORMERS.SecVoltsLow
FROM TRANSFORMERS INNER
UNION ALL
      ...
      See more | Go to post
      Last edited by NeoPa; Dec 23 '08, 10:50 PM. Reason: Please remember to use the [CODE] tags provided
      No activity results to display
      Show More
      Working...